Thread
:
Data Entry In Column 1 with Drop-Down List
View Single Post
#
2
Posted to microsoft.public.excel.misc
Roger Govier[_3_]
external usenet poster
Posts: 2,480
Data Entry In Column 1 with Drop-Down List
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 With Quote
Roger Govier[_3_]
View Public Profile
Find all posts by Roger Govier[_3_]