Hi,
Here is an example of applying data validation between workbooks:
1. In the one workbook name the range containing the items you want listed,
here I named it Months. (highlight the range and choose Insert, Name,
Define, type Months into the Names in workbook box and click OK).
2. Move to the workbook where you want to display the list and choose
Insert, Name, Define and in the Names in workbook box enter List. In the
Refers to enter something of the form
='10-21-2008.xls'!Months
3. Select the range where you want the list and choose Data, Validation, List
4. In the Source box enter =List
If this helps, please click the Yes button
Cheers,
Shane Devenshire
