Unique Records Filter-Updating new entries
 

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
--
Thank You for you''re help!

Unique Records Filter-Updating new entries
 

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.

Jim C wrote:
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
Contextures
http://www.contextures.com/tiptech.html