Hi All
If you look at the attached spreadsheet
I have created a basic validation list.
The first cell i have created a drop down list with a title of Pick a Subject
The cell next to it is titled Corresponding List
What i would like to do is be able to pick a subject in the first list which i have created from a validation list in sheet 2 (this has already been done)
my question now is once i select my list how can i create another validation list from the subject i have chosen and then appear under the title of corresponding list
Sorry if this question has been asked, but i am new to this and trying to get a better understanding of how all this works and the terminology used to do certain task
Much appreciated for your help in advance
Regards
Kyle
validation list.xlsx
Bookmarks