automatically insert new rows in a list
 

Good Afternoon,

I use Excel 2003 in Win XP.

I am creating a spreadsheet that includes multiple "CTRL + L" lists for the
purposes of scheduling concerts.

The lists a
1. pieces to be performed
2. musicians involved
3. rehearsal times
4. Tasks to complete

When I add items to a list, it takes up a row beneath.

My question:
Is there a way to set up the list so that it INSERTS a NEW row instead of
taking the row below? Thus, when I add to a list it pushes the other stuff
down. This way there is not unused space that I must reserve for each list.

I'd like to avoid leaving unnecessary blank rows.

I'm a newish excel user. I carefully read other posts and the help files
without finding an answer. Apologies if I'm asking a redundant question! I
read info about INDEX, and "dynamic ranges" with no luck.

Thanks,
Brighella.

automatically insert new rows in a list
 

Hi Brighella

I'm not sure I understand your problem.
In XL2003, Control + L will invoke DataLists.
The List object is a Dynamic table that grows in size as you add more rows
to it, or if you insert rows.
The "blank" line with the asterisk that appears at the bottom is merely a
place marker for where the next row will go. It is not taking up extra space
in the file until the row is completed.

--
Regards
Roger Govier

"Brighella" wrote in message
...
Good Afternoon,

I use Excel 2003 in Win XP.

I am creating a spreadsheet that includes multiple "CTRL + L" lists for
the
purposes of scheduling concerts.

The lists a
1. pieces to be performed
2. musicians involved
3. rehearsal times
4. Tasks to complete

When I add items to a list, it takes up a row beneath.

My question:
Is there a way to set up the list so that it INSERTS a NEW row instead of
taking the row below? Thus, when I add to a list it pushes the other
stuff
down. This way there is not unused space that I must reserve for each
list.

I'd like to avoid leaving unnecessary blank rows.

I'm a newish excel user. I carefully read other posts and the help files
without finding an answer. Apologies if I'm asking a redundant question!
I
read info about INDEX, and "dynamic ranges" with no luck.

Thanks,
Brighella.