The catch is the names range. Say your range is in WB2.xls, on Sheet1, cells
A1:A10. You need to name this range, for example, myRange.
Then, in WB1.xls, you need to create another named range, for example,
myRange2. Go to menu Insert|Name|Define
define myRange2 as =[WB2.xls]!myRange
Then in your DV, your source for your list would be myRange2.
NOTE: You MUST have both workbooks open to work.
--
John C


"Olivia" wrote:

I was wondering if someone can explain to me the steps to take for creating a
drop-down list from a range of cells using a different worksheet in a
different workbook.

I tried following MS Office Help, but I keep getting the same error message
"You may not use references to other worksheets or workbooks for Data
Validation criteria"