Creating multiple dependent dropdowns

[arnabnestle]

Hello Forum Members,

Requesting your kind help in creating multiple dependent dropdowns in the attached file.

I'm looking for the store name to appear depending on the selected Route code (Dropdown on yellow cells should be dependent on corresponding blue cells) and Item dropdown based on Product category (Dropdown on grey cells should be dependent on corresponding green cells)

Looking forward to your valuable inputs.

Thanks
Arnab

[Pepe Le Mokko]

Here is one of many tutorials https://www.contextures.com/xldataval02.html

[JohnTopley]

See here

https://www.contextures.com/xldataval02.html

beaten to it by Pepe!!!

[torachan]

alternative method - macro driven - needs no formula or data validation - enter date to establish new row in table - clicking in order - next right cell will filter data relative to choice of 'route code' and 'product category'

[arnabnestle]

Dear All,

Thanks for your responses. I tried to doing it both the ways (data validation and macros) and it worked well in the Excel Workbook. However, when I uploaded the file in Google Spreadsheet the dropdowns aren't working. Am I missing something?
Please guide me.

Thanks
Arnab

[torachan]

why would it work in Google

[arnabnestle]

Hi, I want the file to be shared in Google Drive for others to input data, but the dropdown aren't functioning from there. It just shows...Loading

Thanks for your valuable time and feedback