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
|