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:
![vBWjx5o.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FvBWjx5o.jpg&hash=76d88af0ceaba0d17d6c4306cc02fb35)
![MsUYDpG.jpg](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FMsUYDpG.jpg&hash=6800d3b9784206c867abcbda71d38230)