Forum Discussion
Drop down lists from separate workbook
I'm trying to create a drop down list where the source data is in a separate workbook but can't seem to find anything in data validation that allows me to use a different workbook as a source. Any id...
This step by step doesn't work for me. when i attempt to paste into the source field, nothing happens.
Not sure if this is a change in excel since your post or what.
What if:
1. create a sheet in the target workbook, that is linked to the source workbook data
2. use that new sheet as data validation source, because it's in the same workbook as the validated range.
3. hide the new sheet so it's not cluttering up or getting accidentally modified.
Don't have time to try it right now but it's a thought.
