B
Brig
Hello. Got a quick auto-filter question on Excel 2003.
I have 2 sheets: Data & Summary
On the Data sheet, I have a table of transactions for a given month. It has
ClientID, Client Info, TransactionAmount, Discounts, Transaction Date
On the Summary sheet, I have just totals for the entire Month.
What I want to do is to be able do a filter or auto-filter on the Data Sheet
for one
specific ClientID. The summary page then should update the calculations for
the
filtered data.
I tried using Auto-Filter in the data sheet but the formulas is still
calculating the entire data sheet.
Is there a way to do this?
Thank you very much in advance.
Brig
I have 2 sheets: Data & Summary
On the Data sheet, I have a table of transactions for a given month. It has
ClientID, Client Info, TransactionAmount, Discounts, Transaction Date
On the Summary sheet, I have just totals for the entire Month.
What I want to do is to be able do a filter or auto-filter on the Data Sheet
for one
specific ClientID. The summary page then should update the calculations for
the
filtered data.
I tried using Auto-Filter in the data sheet but the formulas is still
calculating the entire data sheet.
Is there a way to do this?
Thank you very much in advance.
Brig