Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I advance filter a large csv file for unique customer #'s | Excel Worksheet Functions | |||
Displaying unique entries from a filtered list | Excel Worksheet Functions | |||
Count Unique Entries | Excel Worksheet Functions | |||
automatically filter for unique records... or other suggestions | Excel Worksheet Functions | |||
Extract Unique Records from two lists | Excel Worksheet Functions |