Reference another sheet...

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
 
F

Frans van Zelm

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
 
M

Michael

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
 
Top