Create a drop-down list from a range of cell

O

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

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.
 
O

Olivia

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

John C said:
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 said:
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top