Hi.
Can anyone help me figure out how to use the data validation to refer to another workbook. Here is the scenario: In Book1-cell B2, I am trying to apply the data validation which would have a drop down list that would refer to Book2 cells A1 - A22. Please note that I am using Vlookup to fill in 5 rows of data underneath cell B2 in Book1 which refers to the associated 5 vertically aligned cells in Book2. I have a formula for the Vlookup to look up data from a different workbook, so I would assume that with data validation I can also use data from a different workbook but my search and efforts are fruitless
Thanks in advance
Bookmarks