I have a data validation cell (A10) on Sheet 1 which is labeled Wensco(=Data!$A$1:$A$11) As you can see my dropdown data is on a sheet labeled (Data). The data contains the list of the following names
Now, here's where I don't know what to do.
Let's say I choose "Digital Media" in the dropdown menu in A10 cell on sheet Wensco.
How can I make a new validation list cell (let's say... sheet Wensco, cell B10) (idepentantly) for each name in the dropdown list? ie. I pick Digital Media, my choices would be "column B".
Now if I pick, let's say "Cut Vinly" my choices would be "column C" not any other column.
And so on...
I hope this makes sense.
Thank you and God bless,
Craig
Now, here's where I don't know what to do.
Let's say I choose "Digital Media" in the dropdown menu in A10 cell on sheet Wensco.
How can I make a new validation list cell (let's say... sheet Wensco, cell B10) (idepentantly) for each name in the dropdown list? ie. I pick Digital Media, my choices would be "column B".
Now if I pick, let's say "Cut Vinly" my choices would be "column C" not any other column.
And so on...
I hope this makes sense.
Thank you and God bless,
Craig