Auto-Filter

  • Thread starter Thread starter Brig
  • Start date Start date
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
 
Most worksheet function do not care whether rows are hidden or not. But the
SUBTOTAL function can be used to ignore hidden rows.
=SUBTOTAL(109,Sheet1!A1:A10) sums only visible rows 1:10.

See Help for more on this function.

--
Jim
| 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
|
|
 
Back
Top