Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How Do I Automatically Refresh Auto Filtered Data?
I have a spreadsheet that is designed using a series of lookups to
automatically populate. THere is a section that is auto filtered to return selected text; however, when the key data is changed the auto filter does not refresh to return the appropriate filtered data. Any suggestions? |
#2
|
|||
|
|||
Greta,
You said "key data" meaning, I think, that the lookup is in the column on which you're filtering. If the looked-up data changes, you'll have to reset the filter, then filter again. If this needs to be dynamic (reflect changes in the looked-up data automatically), an event-fired (Worksheet_Change) macro could reapply the filter. -- Earl Kiosterud www.smokeylake "Greta" wrote in message ... I have a spreadsheet that is designed using a series of lookups to automatically populate. THere is a section that is auto filtered to return selected text; however, when the key data is changed the auto filter does not refresh to return the appropriate filtered data. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Pasting data without the worksheet automatically delimiting it? | Excel Discussion (Misc queries) | |||
Pivot table Data refresh | Excel Worksheet Functions | |||
Automatically Adding Data to Charts | Charts and Charting in Excel | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |