Reference another sheet...

  • Thread starter Thread starter Wild Bill
  • Start date Start date
W

Wild Bill

I want to have a validation drop dpown on sheet 1 and have the data for the
validation on sheet2...How? Thanks Bill
 
Dear Bill,

The other-sheet-data should have a name:
- select you cells
- click in the Name box (Formula bar left, where you see A1)
- type a clear name
- select your validation range
- Data-Validation-tab Settings
- Allow: select List
- Source: press <F3> and select your name

Hope that will do.

Frans
 
Hi Bill
If say, your data is in A1:B10 on sheet2

Put this in your input range box.

Sheet2!$A$1:$B$10
You can do this by simply selecting the sheet and cells with your mouse.

HTH
Michael
 
You must log in or register to reply here.

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

Data Validation in another sheet 1
Macro runtime 1004 error on opening worksheet 5
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Copy dropdown list 1
Offset Named range in Datavalidation List 4
List Validation Lookup Table Help Please 4
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet 1
Consistent Sheet column header rows 2

Back
Top