Advanced Filtering

[RLB]

I'm looking for a way to filter a table similar to the advanced filter...

Is there a way to filter a table of data (from another workbook) when you change the criteria it updates automatically instead of having to re-do the advanced filter every time?

 

[Andrew Poulsom]

You could automate the filter by using the Worksheet_Change event procedure.