Dear All,

I have a workbook ( Sheet1) named POMASTER WITH VALUE RANGE B5:B200 CALLED
PO NUMBER.
I want data Validation in another sheet named Sheet2 in Cell C2.
The PO number is a whole number. Through data validation i want appearance
of all data
RANGE B5:B200 of sheet1 to Sheet2 in Cell C2.( In cell C2 after selection
appear the PO NUmber)

Hope u understand my query.

How can i do this as i did the same into the same sheet but i am quite
truble with doing the
same job in another sheet called Sheet2.

Please assist ?

Rgds,
Aligahk06