VBA: Show Subtracted Figure In Cell When Total Figure Is Entered

[hrayani]

Hello Guys,

I am working on a Daily Production Status Monitoring file.

I do get daily figures from the quality controller but only the total figure (accumulated figure) by the end of the day.

For Example

Lets say if production on day 1 is 100 pieces and day 2 is 110 pieces.
for 1st day i will get a figure of 100
for 2nd day i will get a figure of 210 ( instead of 110) which is the accumulated figure.
so on and so forth.

On 1st day i will manually enter 100 in cell A1
On 2nd day i will manually enter 210 (the accumulated figure) in cell A2.
What i want is when i enter 210 in cell A2 then it should convert it to 110. like it should subtract total of the top cells from the current cell value i.e. of 210 (manually entered) and convert the figure to 110 automatically as soon i press enter.

kinldly let me know if its possible ?

Regards,

Humayun

 

[hrayani]

Actually i waited for a day and found another forum and i posted there.

I apologize, i did not know about the rules.

I am gonna delete right away - the post which i posted in other forum.

 

[RoryA]

You don't have to delete it. Cross-posting is allowed, you just need to let us know where you cross-posted. If you read the rules, it's pretty clear.

 

[hrayani]

Thanks for the reply Ramballah

I will have to insert a seperate column for the solution you provided.

Whereas, i would like VBA to handle it without inserting columns, If Possible.

 

[hrayani]

Oh... Ok

I have posted it here

https://www.excelforum.com/excel-pr...n-cell-when-cumulative-figure-is-entered.html

 

[WaterGypsy]

That's what I would do