| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
| Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
| Pivot table and filter | New Users to Excel | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
| auto filter question | Excel Worksheet Functions | |||
Hybrid Mode
