Is it possible to make a drop down that causes the contents of a second drop down box to change using numbers as headers? I'm still a newbie to this. I have tried using the indirect function to reference the cell containing a validated list.
Is it possible to make a drop down that causes the contents of a second drop down box to change using numbers as headers? I'm still a newbie to this. I have tried using the indirect function to reference the cell containing a validated list.
Last edited by verno74; 10-20-2015 at 10:51 PM.
Hi verno,
I searched on the words "Excel Cascading Dropdown" and found this might be what you need to study.
https://www.ablebits.com/office-addi...n-lists-excel/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks I'll definitely check it out!
Ya everything I'm finding is to with lettered words etc. but no numbers. I can get dependant drop down lists to work with numbers but as soon as I try with numbers, no go. Heres a sample sheet of what I'm trying to attempt. Thank you.
change the Dependent drop down Source to
=INDIRECT("_" & G12)
Did the trick, Thank you very much, I initially tried it but had a typo. Thanks big time.
Last edited by verno74; 10-22-2015 at 04:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks