Use a named range for the DV's source. Then it will work in any sheet in the
workbook. In Sheet1, select the source range: B5:B200, then click
InsertNameDefine, name it as say: MyRange. Then in any sheet, you can apply
the DV using List, Source: = MyRange. Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Aligahk06" wrote:
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