Excel Experts,

I have a number of equations which I have to edit each day.

I receive a MTD commission figure each day which I enter in one cell, B4.

I compute the Daily commission figure in cell A4 using the formula
=today's MTD commission-yesterday's MTD commission

For the edit, I delete the text "-yesterday's MTD commission", then go to
after the equal sign and type in the new MTD commission, then put a minus
before yesterday's MTD commission.

Below is how it works on the spreadsheet:

Day 0 MTD Commission = 5000

Day 1
A B
1
2 Daily MTD
3 Commission Commission
4 =5200-5000 5200
5

DAY 2, MTD Commission = 5600
A B
1
2 Daily MTD
3 Commission Commission
4 =5600-5200 5600
5

My question is, once I have entered the "5600" into cell B4, what code will
do the editing in cell A4 to change it from "=5200-5000" to "=5600-5200"?

Thanks,
Alan


--
achidsey