Link to home
Create AccountLog in
Avatar of Sam OZ
Sam OZFlag for Australia

asked on

Excel cascading of columns

I have a spreadsheet with countries in one sheet and states in another sheet   and district in another sheet ( there are more sheets , but first two sheets are good for this question)


How can I have a sheet where  one column is Country and the next column is  State and the next column is District . When selecting a s Country (For example India)  only  states in that country should appear  in the state column . When a State  (For example Bengal) is selected  the districts in the state should appear in the District column


SOLUTION
Avatar of Rincewindwizz
Rincewindwizz
Flag of Switzerland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account