Create a drop-down list from a range of cell

[Olivia]

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"

 

[John C]

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.

 

[T. Valko]

See this:

http://contextures.com/xlDataVal05.html

 

[Sandy]

Try
http://www.contextures.com/xlDataVal05.html

 

[Olivia]

I followed this way and I still get the same error message on the data
validation. Maybe I'm missing something?

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

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"