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