Filter
 

I have built a spreadsheet that uses autofilters. I have data and a summary
pages to stack the data using formulas annd filter. As I filter I want to
return the valuse I filter on to a cell on the summary page.

Can someone help me with this?

Thanks.

You can use an Advanced Filter to extract data to another sheet. There
are instructions in Excel's Help, and he

http://www.contextures.com/xladvfilter01.html

cmorris28 wrote:
I have built a spreadsheet that uses autofilters. I have data and a summary
pages to stack the data using formulas annd filter. As I filter I want to
return the valuse I filter on to a cell on the summary page.

Can someone help me with this?

Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html