Advanced Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter Error - I cannot spot my Error 3
Advance Filter 4
Storing Multiple Selected Pivot Table Report Filter Values 2
Create list of selected criteria in auto-filter range 2
VBA - retrieve data on last create named range from previous inserted named range 0
Table Filters 12
Advanced Filter - Get the unique rows 2
Excel Bilinear interpolation 1

Back
Top