|Thanks for your reply DerbyDad.|
My needs are pretty basic on this spreadsheet. I'm looking to add an additional row at the 'bottom of the stack' on all of the tabs with formulas copied from the line above.
In the subject spreadsheet, all of the tabs have data up to row 78. Rows 79 & 80 are blank. Row 81 contains formulas that sum up items in various columns.
Row 78 in each tab is unique.
What I'm looking to do in each tab is to copy row 78, insert a new line below it, and paste in the formulas. That new line is inserted above my 'total' line (81), so those formulas should stay intact.
For the sake of ease, we'll call the tabs TAB1, TAB2, TAB3 and TAB 4
For each new line after, it can copy the line above (it does not need to be line 78).
Please let me know if any additional info is needed.