If a certain name in data validation is used I only want a certain list to be available in new data validation cell

[craigwojo]

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

 

[Snakehips]

@craigwojo Your best bet is to search 'Excel multiple related dropdown lists' on YouTube.

There will be dozens of good illustrative videos.

Maybe give this one a try

Hope that helps.

 

[craigwojo]

@craigwojo Your best bet is to search 'Excel multiple related dropdown lists' on YouTube.

There will be dozens of good illustrative videos.

Maybe give this one a try

Hope that helps.

Snakehips,
Wow, very deep. But, that's how to learn.

Thank you