Automatically adjusting # of entries by adding/removing rows

[Alice]

Hello.

I am looking for a solution to remove extra, or add more lines as required
on a worksheet. Information is gathered from several worksheets which varies
from week to week, and tabulating the information onto another spreadsheet.

Is there a way of adding/removing lines automatically as required for a
section of the spreadsheet, and still have the SUM feature adjust and work as
well. “Date/Activity/Amount†is derived from other worksheets. The
spreadsheet will be a template, the entries for each Item will vary from week
to week, and each week is a separate spreadsheet.

Week #1
Item 1 Total Amount: (SUM Amount Item 1)
Date Activity Amount
Date Activity Amount

Item 2 Total Amount: (SUM Amount Item 2)
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount

Week #2
Item 1 Total Amount: (SUM Amount Item 1)
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount
Date Activity Amount

Item 2 Total Amount: (SUM Amount Item 2)
Date Activity Amount
Date Activity Amount
Date Activity Amount

Thank you for your assistance.

 

[Ron@Buy]

Alice
I don't know if I can help but more information about your problem may
produce an answer.
Perhaps even a bit of lateral thinking!
I assume you are only using 3 columns for each week: eg A (Date), B
(Activity) & C (Amount). There only two items per week. If this is the case
why not enter the weeks across the workshheet there are 258 columns (Excel
2003). Then when you "gather" the information from other "spreadsheets" you
have 65536 rows to make entries. Thus the number of "lines" appearing under
each heading will be equal to the number of "lines" "gathered".
Regarding the SUM - why not create the SUM on the source worksheet and
"gather" the sum together with the other information!