Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter
Is there a way, without using VBA code, that I can create an advanced filter
(or similar process) that recalculates automatically when the data table changes? For example I have a table with values for Alt, GPH, and TAS. I add new data to the table each week. I would like to create subset tables for each unique value of Alt. All the unique values of Alt are known. Art |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter
Here is one approach that does not require VBA for even a filter:
After you have added your weekly updates to the table, sort it by ALT. This will cluster the data by the value of ALT. After the sort, copy the rows (or columns) with the same ALT into sub-tables. -- Gary's Student "ArthurJ" wrote: Is there a way, without using VBA code, that I can create an advanced filter (or similar process) that recalculates automatically when the data table changes? For example I have a table with values for Alt, GPH, and TAS. I add new data to the table each week. I would like to create subset tables for each unique value of Alt. All the unique values of Alt are known. Art |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
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) |