Thread: Advanced Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ArthurJ ArthurJ is offline
external usenet poster
 
Posts: 32
Default 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