Add an amount from a calculation to a cell with a calculation (Sample attached)

This is far from straight forward to explain i think it wil lrequire a macro but lets see.

The sample sheet will have;

Volume Target Worked Achieved

1000 1000 500 50%

This is fine for one day.

One the 2nd day i need either a macro or a formula to do the following;

Volume Target Worked Achieved

500

This amount will be added from whats left over from the previous day, your thinking thats just a simple formula but the tricky part is i want to be able to do this;

Manually enter for the 2nd day;

Volume

1250 -> this will be inputted manually and then it will add on whats elft from the previous day aswell.

Confusing i bet, ive attached a sample sheet with notes

Thanks,

A Change event is the logical approach, yes.

Perhaps you want something along the lines of:

Please Login or Register  to view this content.

to insert the above right click on sheet select View Code and paste above into resulting window... thereafter in Macro enabled file altering G10 manually will generate a revised total being the sum of the manual entry and the prior balance.

(I suspect you will want to apply this logic to more than one cell, if so you will need to provide a further example illustrating the layout in more detail so we can see the relationship between the cells)

I added another column so;

Column 1 contains todays Volume of work
Column 2 contains a formula like this;

=SUM(M5)+P5

seems to work ok, the Macro also works so thanks a lot.