Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel |