Data Validation in another sheet

A

Aligahk06

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
 
M

Max

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
Insert>Name>Define, 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top