Validation

Z

zoot

I am trying to validate a cell using the Validation drop down box.

I have a list of items and I want this to make up the list, however the list
is in a seperate worksheet within the same workbook. Can someone please
help me reference these cells for the drop down list.

Thank you
Dan
 
J

John James

Try this:

Give the list a rangename e.g. MyList

In data validation - list dialogue box enter this range as a formula
=MyList
 
M

MDBJ

validation data has to be on the same worksheet.

you can have a zone on the current worksheet that = the other sheet (with
the data)
 
Top