Forum Discussion
How to create Dependent drop down list using two workbooks
Hello, I am trying to create a dependent dropdown list which includes 2 separate workbooks (excel document). 1st is where the drop down data in saved and 2nd is where I want to create a dependent...
Hi Avinash1720
it is technically not possible in Excel to use dropdown lists where the source is located in a different workbook. And even if it was, I would highly recommend not to do so, you would be in trouble sooner or later (source file gets moved, renamed, etc.)
Instead, if it is really necessary to keep the workbooks separated, I would recommend to dynamically import the source data into the target workbook using Power Query. This way, you have everyhing in one place to create proper dropdown lists. And on the other hand, you can continue to maintain the source data in a different workbook.
Thanks for the response. I'll explore the power query option.