Data Validation List

G

Guest

I'm trying to place a drop down list in a cell and it is
not working. I placed it on one worksheet, but it doesn't
work on the other. I put what I want to drop down (6
items, each in a separate cell), but the list doesn't
show. Any suggestions?
 
A

Alan

You cannot use a range of cells, say Sheet2!A1:A6 in Data Validation, but if
you name the range as MyList or whatever and use =MyList in the cell in
another sheet, it will work,
Regards,
 
B

Bob Phillips

If you want it to refer to a range on another sheet, you need to name that
range, and use the name in the DV list.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top