G
Guest
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
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