| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need an auto update formula macro
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-update column formula | Excel Discussion (Misc queries) | |||
| Macro Auto-update of data labels | Excel Worksheet Functions | |||
| Excel Macro - Auto Update Links | Excel Programming | |||
| Can I disable auto formula update? | New Users to Excel | |||
| Auto refresh and DDE update is not work when running macro | Excel Programming | |||
Threaded Mode
