Hi - see the excel file attached. I want to prevent the selection of one dropdown based on the selection of another.
Hi - see the excel file attached. I want to prevent the selection of one dropdown based on the selection of another.
Hi,
You can do this without code. Define a name called ValidDates using this formula
=INDEX('Background data'!$B$2:$B$13,MATCH(Sheet1!$B$3,'Background data'!$B$2:$B$13,0)+1):'Background data'!$B$13
and then assign =ValidDates as the validation list for C3.
Don
Please remember to mark your thread 'Solved' when appropriate.
deleted by tim
Last edited by tim201110; 01-19-2017 at 01:49 PM. Reason: misunderstanding
@ xlnitwit - great answer - thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks