Macro to change the value of a cell based on the value of another

**Jhansen5452** · 12-08-2012, 02:14 PM

I need to change the value in C based off of B. If B is says "R,G or SS" C needs to be 1 number greater than the cell above it, if B is empty then C needs to remain empty.

**Moo the Dog** · 12-08-2012, 03:04 PM

You need a macro for that? How about just a simple formula like this:

=IF(SUM(IF(B8={"G","R","SS"},C7+1,0))=0,"",C7+1)

- Moo

**Jhansen5452** · 12-08-2012, 03:11 PM

I tried that, but there is a macro putting in a static date stamp in another column based off the value in C. When I put the formula in the macro activates prematurely

**Moo the Dog** · 12-08-2012, 03:31 PM

Ahh, good enough. I'll have to defer to the VBA pros on the forum for that one then. I tried.

- Moo

**Jhansen5452** · 12-08-2012, 03:32 PM

Problem solved, I changed the static date macro target range cells so I can use that formula in C. Thanks for the assistance. Don't know why I didn't thinkof that to begin with. It dawned on me after I replied to your post.