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!