Drop Down Lists for Multiple cells | General Excel Questions & Answers | Excel Forum

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.

http://www.utteraccess.com/wik.....down_Lists

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. 

Thanks 

Elliot