Wow, you are fast Roger. Thanks for the input. I have already looked at
Debra's website, in fact it's one of my favorites when I go looking for Excel
solutions. She has some good techniques for dependent validation lists but I
could find anything about using a filtered dataset as source data.

I have a long list with diverse parts number data in it and I need to filter
a single column in that list for a parts numbers (unique) with a particular
prefix and use that data for a Validation list.

I know I can do an advanced filter to another range and then reference that
range to get the List data but then I have to continually refresh the
filtered data each time I want to use the drop down list. It's possible but
I'm not to brilliant with VBA and it would require some of that to keep
everything updated...I think. Just looking for a formulaic method.

Rgds,
RDW

"Roger Govier" wrote:

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