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.