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
View attachment validation list.xlsx
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
View attachment validation list.xlsx