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!