How do I set up a validation list?
 

I have created a database query (sql) to import data into a list that I want
to use for a drop down list. However, the column header appears as one of
the list's items. Is there a way around this? Would the combo box be a
better approach? Thanks for any assistance.

How do I set up a validation list?
 

bburnett,

Where is this list at (what are the cell addresses for this the range of
this list)? Is this list for data validation on the same sheet or a
different sheet? Are there named ranges involved?

Can't you just adjust the address of the DV's Source range to exclude the
cell the column header shows up in?
Select the cell that has the DV drop down list, then: Data Validation...
Settings tab Source: box.

HTH,

Conan




"bburnett" wrote in message
...
I have created a database query (sql) to import data into a list that I
want
to use for a drop down list. However, the column header appears as one of
the list's items. Is there a way around this? Would the combo box be a
better approach? Thanks for any assistance.

How do I set up a validation list?
 

There are named ranges involved and they are on a different sheet in the same
workbook. The lists are generated from a SQL query and the header comes
along. When the lists were created, the box for headers was checked. I have
tried changing the range for the names ranges but unsuccessfully so far. I
am not sure if that answers your question or not...

"Conan Kelly" wrote:

bburnett,

Where is this list at (what are the cell addresses for this the range of
this list)? Is this list for data validation on the same sheet or a
different sheet? Are there named ranges involved?

Can't you just adjust the address of the DV's Source range to exclude the
cell the column header shows up in?
Select the cell that has the DV drop down list, then: Data Validation...
Settings tab Source: box.

HTH,

Conan




"bburnett" wrote in message
...
I have created a database query (sql) to import data into a list that I
want
to use for a drop down list. However, the column header appears as one of
the list's items. Is there a way around this? Would the combo box be a
better approach? Thanks for any assistance.

How do I set up a validation list?
 

bburnett,

For XL 2002/2003 (not familiar with 2007):
1. Insert Name Define...
2. In the "Names in workbook:" list, select the name that you want to
change range for.
3. In the "Refers to:" text box, adjust the range to exclude column lables.
4. Click the "Add" button.
5. Repeat 2-4 for other named ranges, or click the "OK" button.

If you need more help, please provide names used and their "Refers to:"
address.


PS. I'm not positive, but if the name that DV is refering to is the name
automatically created by the external query, that name might be recreated
each time the query is refreshed. You might have to create your own named
range to exclude the column lable and use this new name as the source for
your DV. If the list returned by the query is constantly changing, you can
create a dynamic named range that will automatically adjust each time new
items are added to the list.

HTH,

Conan







"bburnett" wrote in message
...
There are named ranges involved and they are on a different sheet in the
same
workbook. The lists are generated from a SQL query and the header comes
along. When the lists were created, the box for headers was checked. I
have
tried changing the range for the names ranges but unsuccessfully so far.
I
am not sure if that answers your question or not...

"Conan Kelly" wrote:

bburnett,

Where is this list at (what are the cell addresses for this the range of
this list)? Is this list for data validation on the same sheet or a
different sheet? Are there named ranges involved?

Can't you just adjust the address of the DV's Source range to exclude the
cell the column header shows up in?
Select the cell that has the DV drop down list, then: Data
Validation...
Settings tab Source: box.

HTH,

Conan




"bburnett" wrote in message
...
I have created a database query (sql) to import data into a list that I
want
to use for a drop down list. However, the column header appears as one
of
the list's items. Is there a way around this? Would the combo box be
a
better approach? Thanks for any assistance.