Hi

Take a look at Debra Dalgleish's site for lots of help on DV.
Without more information about what the list looks like, or the filtered
set of data and the criteria, I can't say if you can do what you want
without creating the filtered list first.

But, if you look at the numerous examples Debra has created, you may see
a method to suit you.
http://www.contextures.com/xlDataVal13.html

--
Regards

Roger Govier


"RD Wirr" wrote in message
...
I am trying to make a Validation drop down list with the list source a
set of
data from an advanced filter. I can make an extra worksheet to put the
filtered data in before using it as a source for the drop down list.
But I
was just wondering if anyone knows of a way to do this directly as a
range
formula in the Validation List Source.
Thanks,
RDW