Here's the sheet.

cell A40=SUM(E41:*E54*)
cell C43=SUM(*E55*:E80)
cell I45=current #
cell I47=prior #

I want to be able to run a macro that will do in this ORDER the
following logical steps:

If I47 = I45
then updated A40's formula to "=sum(E41:*E55*)"
then update C43's formula to "=sum(*E56*:E80)
Else copy I45's # and paste into I47
then updated A40's formula to "=sum(E41:*E55*)"
then update C43's formula to "=sum(*E56*:E80)

Basically its just moving the cell ranges forward one for me as shown
by the bolding. Anybody know how I can do this?


--
foxspirit
------------------------------------------------------------------------
foxspirit's Profile: http://www.excelforum.com/member.php...o&userid=31264
View this thread: http://www.excelforum.com/showthread...hreadid=512253