ExcelBanter - Data Validation Problem

Figured it out now....

Cheers

Mark

"Mark S" wrote:

Hi

I am trying to create a drop down list for a cell using data validation. I
need my data source to be on a different worksheet so I can easily edit it.

How do I reference the data on a different worksheet in the data validation
source field?

I have set up a defined name for the list of cells I need to reference to
make it simpler, however I get the error message that I cannot reference
cells not on the same worksheet as the drop down list... The help file says
however that this is possible ..

Any help would be appreciated