I have created a data validation rule in some cells of a worksheet giving me
a drop down box to choose from a list which is located on another worksheet.
However, the 'header' of the list appears as one of the drop down choices
and this should not be.
Any help is much appreciated

You don't identify how you reference the data in list. One way is to NAME
the range of cells (leaving out the header). Then on the Validation List,
just put =LIST in the Source Box. You don't have to reference the worksheet
if different.

Also check out: http://www.contextures.com/xlDataVal03.html

Les



"Dave" wrote:

I have created a data validation rule in some cells of a worksheet giving me
a drop down box to choose from a list which is located on another worksheet.
However, the 'header' of the list appears as one of the drop down choices
and this should not be.
Any help is much appreciated

Don't include it in the list then, maybe put the text in the cell above, or
in the input message.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dave" wrote in message
...
I have created a data validation rule in some cells of a worksheet giving
me
a drop down box to choose from a list which is located on another
worksheet.
However, the 'header' of the list appears as one of the drop down choices
and this should not be.
Any help is much appreciated

When creating the list I chose the option ticked the box to say that the
'list has a header'. Then I highlighted the list and named it.
At what stage should I leave out the header?
I tried creating a list with out a header, but then excel inserts a header
'column1' which then appears as a choice on the drop down list!
thanks

"WLMPilot" wrote:

You don't identify how you reference the data in list. One way is to NAME
the range of cells (leaving out the header). Then on the Validation List,
just put =LIST in the Source Box. You don't have to reference the worksheet
if different.

Also check out: http://www.contextures.com/xlDataVal03.html

Les



"Dave" wrote:

I have created a data validation rule in some cells of a worksheet giving me
a drop down box to choose from a list which is located on another worksheet.
However, the 'header' of the list appears as one of the drop down choices
and this should not be.
Any help is much appreciated

Do not create the list using the DataListCreate list which I believe you are
doing.

Just select the range of cells to include in the DV list and InsertNameDefine.

Give it a name then use that name in DV source.........=MyList


Gord Dibben MS Excel MVP

On Tue, 11 Dec 2007 05:33:01 -0800, Dave wrote:

When creating the list I chose the option ticked the box to say that the
'list has a header'. Then I highlighted the list and named it.
At what stage should I leave out the header?
I tried creating a list with out a header, but then excel inserts a header
'column1' which then appears as a choice on the drop down list!
thanks

"WLMPilot" wrote:

You don't identify how you reference the data in list. One way is to NAME
the range of cells (leaving out the header). Then on the Validation List,
just put =LIST in the Source Box. You don't have to reference the worksheet
if different.

Also check out: http://www.contextures.com/xlDataVal03.html

Les



"Dave" wrote:

I have created a data validation rule in some cells of a worksheet giving me
a drop down box to choose from a list which is located on another worksheet.
However, the 'header' of the list appears as one of the drop down choices
and this should not be.
Any help is much appreciated