Create multiple dependent drop-down lists in Excel 365 for Mac

[Joneye]

I would like to create a two tabbed document.

Tab 1 People will select from one drop down list, with the second drop down list looking up only from the first lists
Tab 2 Here is where the lists will be kept

I'm trying to find a tutorial that will help me, or a thread. Or advise how i can upload a file to explain it better.

 

[awoohaw]

Take a look at post #10 in this thread. Also, take a look at the video linked below:

Dependent Drop Downs

Hello I'm not really sure what terminology I'm needing, but based on some google searches, I'm assuming they are dependent drop downs. So in sheet 1 I have the data. At the moment, they are coping and pasting the vendors they want to use, but I want to create sheet 2, where they can click from...

www.mrexcel.com

 

[Drrellik]

That is a good video above, I was watching a video yesterday from LG that has something very close to this just done a different way,