How do I set up a validation list?

  • Thread starter Thread starter bburnett
  • Start date Start date
B

bburnett

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.
 
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
 
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...
 
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
 
Back
Top