new row without effecting equations

here's the problem -

woorkbook with 12 worksheets, that contain 12 columns, and 50 rows of data
each.
there are auto sums running on many of the rows and colums.
there is at least one column where the rows sum across all worksheets from
start to end.

i need to add more rows in the middle of the worksheets but want to
accomplish this without having to correct all of the auto sums and especially
the sums that calculate the worksheets as a group.

currently, when a row is added at 40, the data originally in row 40 moves to
41 but still looks for data in row 40 across all worksheets.

if i have to change each cell manually to account for the addition of the
new rows it could be a couple hours worth of work.

any ticks?!?

If each sheet is exactly the same format, select the first tab in the
workbook, hold shift and select the last tab in the workbook. then
make your changes on the selected sheet and the changes will be made
on every tab you selected.


If the sheets aren't in order, you can hold down ctrl as you select
the sheets.

On Jul 15, 1:35*pm, NJK wrote:
here's the problem -

woorkbook with 12 worksheets, that contain 12 columns, and 50 rows of data
each.
there are auto sums running on many of the rows and colums.
there is at least one column where the rows sum across all worksheets from
start to end.

i need to add more rows in the middle of the worksheets but want to
accomplish this without having to correct all of the auto sums and especially
the sums that calculate the worksheets as a group.

currently, when a row is added at 40, the data originally in row 40 moves to
41 but still looks for data in row 40 across all worksheets.

if i have to change each cell manually to account for the addition of the
new rows it could be a couple hours worth of work.

any ticks?!?