Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry In Column 1 with Drop-Down List
I have a table being used to enter class-specific data for students. The
first column /field is a drop-down list of the different classes linked to a dynamic range elsewhere. Normally, typing anything in the new row "adds" a data record and drop-downs appear as desired, but not in this case with the drop-down in the first column. I know how to work around this manually (enter something in one of the typed-entry fields), but this is for use by a client and needs to be as automated as possible. Besides, all the other entries are based on that first selection from the drop-down list. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry In Column 1 with Drop-Down List
Thanks for the information Govier. I already have the table defined with the
first record (row) entered as an example for the user. What I need is a way to add addition records with the drop-down list being used as data validation in the first field (column) of each record. Ed "Roger Govier" wrote: Hi Ed If you are using XL2003, select a cell in your Table and then DataListCreate, after you have applied DV to the cells in column A. As you create new lines, DV will automatically be applied to the new rows. If you are using XL2007, use InsertTable -- Regards Roger Govier "Ed Mabe" <Ed wrote in message ... I have a table being used to enter class-specific data for students. The first column /field is a drop-down list of the different classes linked to a dynamic range elsewhere. Normally, typing anything in the new row "adds" a data record and drop-downs appear as desired, but not in this case with the drop-down in the first column. I know how to work around this manually (enter something in one of the typed-entry fields), but this is for use by a client and needs to be as automated as possible. Besides, all the other entries are based on that first selection from the drop-down list. Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry In Column 1 with Drop-Down List
Hi Ed
That is exactly what happens, if the DV has been set before the List is created. -- Regards Roger Govier "Ed Mabe" wrote in message ... Thanks for the information Govier. I already have the table defined with the first record (row) entered as an example for the user. What I need is a way to add addition records with the drop-down list being used as data validation in the first field (column) of each record. Ed "Roger Govier" wrote: Hi Ed If you are using XL2003, select a cell in your Table and then DataListCreate, after you have applied DV to the cells in column A. As you create new lines, DV will automatically be applied to the new rows. If you are using XL2007, use InsertTable -- Regards Roger Govier "Ed Mabe" <Ed wrote in message ... I have a table being used to enter class-specific data for students. The first column /field is a drop-down list of the different classes linked to a dynamic range elsewhere. Normally, typing anything in the new row "adds" a data record and drop-downs appear as desired, but not in this case with the drop-down in the first column. I know how to work around this manually (enter something in one of the typed-entry fields), but this is for use by a client and needs to be as automated as possible. Besides, all the other entries are based on that first selection from the drop-down list. Thanks in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Entry In Column 1 with Drop-Down List
Yes, I got it to work after I set the DV for all the cells in the field below
the Field Header cell. I had only set the first row, which then depends on auto expansion of the table to "add" the DV dynamically as each row is added. Thanks, Ed "Roger Govier" wrote: Hi Ed That is exactly what happens, if the DV has been set before the List is created. -- Regards Roger Govier "Ed Mabe" wrote in message ... Thanks for the information Govier. I already have the table defined with the first record (row) entered as an example for the user. What I need is a way to add addition records with the drop-down list being used as data validation in the first field (column) of each record. Ed "Roger Govier" wrote: Hi Ed If you are using XL2003, select a cell in your Table and then DataListCreate, after you have applied DV to the cells in column A. As you create new lines, DV will automatically be applied to the new rows. If you are using XL2007, use InsertTable -- Regards Roger Govier "Ed Mabe" <Ed wrote in message ... I have a table being used to enter class-specific data for students. The first column /field is a drop-down list of the different classes linked to a dynamic range elsewhere. Normally, typing anything in the new row "adds" a data record and drop-downs appear as desired, but not in this case with the drop-down in the first column. I know how to work around this manually (enter something in one of the typed-entry fields), but this is for use by a client and needs to be as automated as possible. Besides, all the other entries are based on that first selection from the drop-down list. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
drop down list shows first blank row after last list entry | Excel Discussion (Misc queries) | |||
Populate a column of data with a formula using a drop down list | Excel Discussion (Misc queries) | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
drop down list - save the entry | Excel Discussion (Misc queries) |