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"

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"

See this:

http://contextures.com/xlDataVal05.html

--
Biff
Microsoft Excel MVP


"Olivia" wrote in message
...
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"

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

"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"

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

"John C" wrote:

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"