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

Perhaps I'm being too simple here, but could you not use

='Day 2 MTD Commission'!B4 - 'Day 1 MTD Commission'!B4

You'll need to later the bit in ' ' to the actual sheet names being used,
but it should work.

Perhaps I don't understand?

HTH.

"achidsey" wrote:

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