Data Validation in another sheet
in [General]
|
Prev: Error Too Many Different Cell Formats (Different than others have
Next: Pivot Table Expand Collapse not showing for Cube
From: Aligahk06 on 30 Sep 2009 04:01 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
From: Max on 30 Sep 2009 04:17
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 --- "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 > |