Totals rows dynamically moving to accommodate amount of informatio

[Guest]

I have a summary sheet that gathers information from various tabs in a
workbook. Each other tab's information is listed in a new row. I may have
as few as 5 other tabs or as many as 50. This creates a set of 7 columns
that are totaled on four rows at the bottom of the sheet. These totals are
currently set at rows 38 to 41. I would like these four rows to move
dynamically to accommodate the amount of tabs I am totaling so there are not
rows of zeros displayed when there are fewer than 36 tabs (currently I have
the summary sheet set up to hold 36 other tabs and any unused rows are left
filled with zeros.) Any help would be much appreciated!
-Kai

 

[Guest]

put your sums in rows 4 to 7 and have the sum formulas refer to rows 2:3.

Now when you bring a row over, insert it above row 3. Keep track of where
row 3 moves to so you always insert above that row. The sum formulas will
expand and always be relative to the original row 3 as it it pushed down the
sheet.

If you are going to reuse the sheet for new data, then delete all the old
data rows to restore it to the above.