Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter - Automatic Update
I'd like to allow individuals to enter in filter variables in one or two
lines and have the spreadsheet automatically process these filters and automatically refresh the spreadsheet. Does anybody have general macro language (i'm assuming a macro is the only way to go) to accomplish this? (I'm guessing it would have to check to see if filter data is enterred in one or both lines and adjust the ranges accordingly) Is there a better way? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |