Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reference another sheet...
I want to have a validation drop dpown on sheet 1 and have the data for the
validation on sheet2...How? Thanks Bill |
#2
|
|||
|
|||
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 "Wild Bill" wrote in message news:5hCFd.21618$ql2.8249@okepread04... I want to have a validation drop dpown on sheet 1 and have the data for the validation on sheet2...How? Thanks Bill |
#3
|
|||
|
|||
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 "Wild Bill" wrote: I want to have a validation drop dpown on sheet 1 and have the data for the validation on sheet2...How? Thanks Bill |
#4
|
|||
|
|||
thanks but I figured it out...
"Wild Bill" wrote in message news:5hCFd.21618$ql2.8249@okepread04... I want to have a validation drop dpown on sheet 1 and have the data for the validation on sheet2...How? Thanks Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS | Excel Discussion (Misc queries) | |||
Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) |