Data validation to refer to different workbook

[kosherboy]

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

[Pete_UK]

Please do not multi-post and produce duplicate threads (see Forum Rule 05). Most of us will read through most of the Forums, so there is no need for it.

Pete