Create duplicate cells that you want to refer to on your input
worksheet. Let's say your input worksheet is Sheet1 and ranges you want
to validate the input against in Sheet 2 and 3.

Sheet1!A1=Sheet2!B10
Sheet1!A2=Sheet3!C45

Now you can use data validation by using values on A1 and A2 on Sheet1.


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528159