Unique Records Filter-Updating new entries

[Guest]

I've applied an advanced filter for unique records on several list that are
in the same worksheet. I want to use these filtered list in several drop down
list(data validation) in a another worksheet. The problem I'm having is that
if a new record is added to the original list it does not display in the
filtered list. How can I make the filtered list update when data is added in
the original list. I'm hoping there is a pre-built function for this because
I'm a novice at VBA. THanks

 

[Debra Dalgleish]

There's no built-in function that will automatically update the list
created by an Advanced Filter.

You could record a macro as you apply the advanced filter to a column,
then run that macro after updating the original list.