transfer cell $ amount to other sheet month-to-month without overc
 

I am trying to do a budget plan for an entire year going into the next. I am
trying to have it transfer the savings ($ amout) of the current month to the
next month and have the that saving be added to any possible savings of the
next if it is to be. here is what i have in theary: If the item in cell "H30"
is possitive but also greater than the item in cell "K42", show a savings and
have it be transfered to the next month budget plan.
is that a possible task?

For the current sheet, to show the amount that will be transferred,

=if(and(h300,h30k32),h30-k32,0)

or, for the next sheet

=IF(AND(Sheet1!H300,Sheet1!H30Sheet1!K32),Sheet1 !H30-Sheet1!K32,0)

etc


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390784