Bring Forward Balances and Formulas in a Spreadsheet

[Guest]

I have a spreadsheet that keeps a running balance of several employees' hours
worked by program and the funds remaining for each employee to charge to that
program based on their wages. Each pay period, I need to be able to bring
forward the balances from the previous pay period into a new worksheet. The
spreadsheet contains formulas for calculating and rounding and I need those
formulas to also copy to the next pay period spreadsheet. I tried posting a
part of my spreadsheet in my last request but the lines were all askewed.

Susan

 

[Susan]

i do something similar with funding balances, but by column, not by
spreadsheet - charging time to funding invoices.

what i'd suggest is (all automated via macro, of course) - copy the
original spreadsheet, rename it to the new payperiod or month or
whatever.
on the new spreadsheet, copy and then paste VALUES of the #s you still
need where you need them. clear the rest of the range. then have the
macro re-enter your regular formulas (if necessary) like SUM, etc.

then your formatting will stay the same & your beginning balance is
now hard-coded at the top of this page.
i do it by adding a new column, copy & paste data (formulas) in new
column, copy & paste values into old column, etc.

hope the idea helps you out.

susan
(the other one)