Dynamic dependent List drop down in Excel

[bikashbehera95]

Hello,

I have a database of 3 columns. I want to create a 3 hierarchy drop down.
My table is something like this. Each drop down is dependent on previously selected option.
IMAGE :

I want the drop down to look something like this. Database table would be updated time to time.

Image:

Please provide me way to go about it.

 

[AliGW]

Cross-posted without links: https://www.excelforum.com/excel-fo...ynamic-dependant-list-drop-down-in-excel.html

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).

 

[bikashbehera95]

Pardon me. Being a new user I was unaware of this rule. I will rectify this right away.

 

[bikashbehera95]

I've found a very related question on stackoverflow. Anyone can extend on the same line to give me three ranges for three different field but lists will be dynamic. I hope this helps you gurus.
Here is the link : Hierarchial dynamic dropdown list in Excel - Stack Overflow