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...
I attempted this using a whole sheet of VLOOKUPs. It technically worked - for a moment - but then it astronomically increased the size of the data validation document (33MB!) It wrecked it so completely that I had to scrap the day's work and re-start from the day before's backup copy. I don't recommend it.