June 24, 2016
I am trying to create a set of dependent drop-down lists, i previously found the method below which worked really well for me as the data in the drop downs is subject to change and hence the pivot tables deal with this change well.
However due to the way the above works this method only works for a drop down list in a single cell.
My question is, is it possible to modify the above method so that i can have the same drop down lists in multiple cells? For example say the first drop down list is in A2, the second list in B2, the third in C2 and so on; i need the same list as in A2 in A3 and A4 etc.. and the same that is in B2 in B3 and B4 etc...
If this is not possible is there any other ways for me to do this? I know that i could create the lists manually and do it this way however they can be very large and can change quite often so they need to be able to be updated, preferably without me manually creating/adding to the lists each time.
July 16, 2010
In this post under the heading "Duplicate State/City Solutions" (towards the bottom), item 4 offers a method to allow the use of the dependent data validation in multiple cells.
Most Users Ever Online: 57
Currently Online: Catalin Bombea, mymalone
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
John Ryan Kivela
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas