See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steph" wrote in message
...
Hello. I have a simple table with 2 columns. In col A, the words "Open"
or
"Closed". In column B, a vendor. On a different sheet, I would like to
have data validation drop-down with ONLY the vendors that have "Open" next
to them. Possible? Thanks so much!