L
Labkhand
Dear all,
I need to auto-populate a list. I have followed a few discussion links on
how to do this task but I am stuck since the VB code does not work and kept
giving me errors! So I gave up and removed the code! :-( But I really
need to make this work! I would really appreciate it if someone could help
me out. Here is what I have:
On the VARS sheet, I listed multiple dates (NOV-2007, Dec-2007, Jan-2008)
under the columns A2 to A4; with A1 holding the list lable "Available Dates".
Next, I created a list through the DATA->LIST->CREATE LIST (checked My List
Has Headers) option by selecting A1..A4.
Finally, I selected cells A2..A4 and named them "AvailableDates", by using
the INSERT->NAME->DEFINE option.
On my DATA sheet, the Data Validation for all cells in column "A" is the
LIST (=AvailableDates).
Now my problem: I need to auto-populate the "AvailableDates" list which
resides on the VARS sheet whenever I add a new date under the column "A" of
the DATA sheet.
Thanks for any help in advance.
I need to auto-populate a list. I have followed a few discussion links on
how to do this task but I am stuck since the VB code does not work and kept
giving me errors! So I gave up and removed the code! :-( But I really
need to make this work! I would really appreciate it if someone could help
me out. Here is what I have:
On the VARS sheet, I listed multiple dates (NOV-2007, Dec-2007, Jan-2008)
under the columns A2 to A4; with A1 holding the list lable "Available Dates".
Next, I created a list through the DATA->LIST->CREATE LIST (checked My List
Has Headers) option by selecting A1..A4.
Finally, I selected cells A2..A4 and named them "AvailableDates", by using
the INSERT->NAME->DEFINE option.
On my DATA sheet, the Data Validation for all cells in column "A" is the
LIST (=AvailableDates).
Now my problem: I need to auto-populate the "AvailableDates" list which
resides on the VARS sheet whenever I add a new date under the column "A" of
the DATA sheet.
Thanks for any help in advance.