Good afternoon all,
I have created a drop down list (using data validation) in column A say from rows 1 to 100.
Now I would only like the the drop list to appear in column A when the adjacent cell in column B is not blank.
Any thoughts?
Thanks in advance
Mark
I have created a drop down list (using data validation) in column A say from rows 1 to 100.
Now I would only like the the drop list to appear in column A when the adjacent cell in column B is not blank.
Any thoughts?
Thanks in advance
Mark