Hi
I have few columns of dependent lists and I want to show a value in the corresponding columns automatically by selecting a value from a drop down list in the first column.
for Example - in the attached Sheet 4, Cell F2, I have a list of places and from Column G to J are all dependent to the previous column. Now If I select a Place in the cell F2 the corresponding cells should automatically return the first data from the respective drop down list. However, I should also be able to change them if required. Is this possible?
Thanks for helping
Pal
Bookmarks