Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh with Advance Filter Applied
Is it possible to set Excel to update a datasheet with an Advanced Filter
applied? I have a summary worksheet that combines totals from 12 monthly worksheets. A chart displays the data from the summary worksheet. The individual and summary worksheets contain mandatory tracking criteria, but in most cases only a few of the criteria are actually used in any individual workbook. To prevent the chart that displays the data from displaying all the criteria I have created an Advanced Filter that eliminates the criteria for which no occurances have been entered. The problem is that once the filter is set, if a new criterion is used it does not appear in the summary sheet until the filter is removed. I then have to manually reapply the filter to eliminate unwanted/unused criteria from the chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter | Excel Discussion (Misc queries) | |||
filters how do i keep the display list empty until filter applied | Excel Discussion (Misc queries) | |||
How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
about advance filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |