making a cell zero out after calculation
 

Well Im having a hard time with this im not real good with macros
What Im trying to do is as I enter the data before I exit put a number in
A2 and minus it from C2 Then A2 zeros out after calc

Then if I want to add inventory I would like to add D2 to C2 then D2 zero's
out after calc
and do this for the hole sheet
Am I just making this harder than it is?

making a cell zero out after calculation
 

What is wrong with the suggestions offered?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"chris1bcoo" wrote in message
...
Well I'm having a hard time with this im not real good with macros
What I'm trying to do is as I enter the data before I exit put a number in
A2 and minus it from C2 Then A2 zero's out after calc

Then if I want to add inventory I would like to add D2 to C2 then D2
zero's
out after calc
and do this for the hole sheet
Am I just making this harder than it is?