Hi,

I have a series of drop down lists on the same row in by excel spreadsheet. When an item is selected from one of the drop down lists (For example the second item in the first drop down list). I want to make all the other drop down lists on this row move to the second item in their list too. I think to do this I need to make the drop down lists dependent on one another, but after looking online I can't find a way to do this.

I am populating the drop down lists from VBA code, the items are not stored in a table within the sheet.

Thanks for your time and I would appreciate if anybody could help me with this.

Thanks