Data Validation between worksheets

G

Gail

Can you have a data validation with a a drop down list
created from a different worksheet that is in your excel
document.

For example
Sheet 1 cells A1:A10 contains a list of items
Sheet 2 I would like to have a drop down list created in
B2:B25 but I want to pull the data from sheet one.

I tried to do this but Excel will not allow me to select
sheet 1 in the source field of the validation dialog box.

Any suggestions I am using Excel 2002
Thanks
 
J

JE McGimpsey

Name the Sheet1 range, say "rng"

In the Validation dialog, enter Allow List, "=rng" (without quotes).
 

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

Similar Threads

VBA Coding Help for Beginner 0
Conditional Validation In Excel 1
How do I get a Data validation list to select another validation l 1
Combo box 0
drop box/data validation help 0
Worksheet protection prevents Data Validation code from running... 1
Data Validation 2
Cannot sort a table containing text 5

Top