I would like to figure out a way to parse through an excel sheet and replace cell values with a formula. I'm guessing this is done with a macro but I've never created macros on my own and so I am not sure how to start.
In the example I want to check if cell A10 is a number in which case, D10 to be replaced with the value of D10+E10, E10 to be replaced with zero and H10 to be same as G10.
Posting screenshots as I can't attach files:
In the example I want to check if cell A10 is a number in which case, D10 to be replaced with the value of D10+E10, E10 to be replaced with zero and H10 to be same as G10.
Posting screenshots as I can't attach files:

