Put an X in a cell based on data in 2 other cells?

[TAPS_MikeDion]

Hi All,

Is there a formula that can be put into a macro to place an X in a cell based on data in two other cells?

What I'm trying to do is create a macro that when run will put an X in column C (starting from C5 to C???) only if there is either a numeric value in cell I5 or an X in cell J5. And this would need to run through from C5 to the last row in column C with data.

As always, thank you for any help given!

 

[TAPS_MikeDion]

Fluff to the rescue AGAIN!

Thank you. Works perfectly. You're the best!

 

[Fluff]

My pleasure.

 

[TAPS_MikeDion]

Hello all,

After all this time I just came across another issue. If an X exists in column B, then I would need the formula to NOT put an X in column C for that row.

Please and thank you to anyone who can help!

 

[Fluff]

You can just add the new criteria like

Sub Taps()
   With Range("C5:C" & Range("I" & rows.Count).End(xlUp).Row)
      .Value = Evaluate("if((not(isnumber(" & .Offset(, 6).Address & ")))*(" & .Offset(, 8).Address & "="""")*(" & .Offset(, -2).Address & "<>""X"")*(" & .Offset(, -1).Address & "<>""X"")*((" & .Offset(, 7).Address & "="""")+(" & .Offset(, 7).Address & "=0)),""X"","""")")
   End With
End Sub

 

[TAPS_MikeDion]

Worked, thank you Fluff!!!

And, thank you for the explanation of the change. That will make things easier in the future, and I won't have to bother anyone for a simple change, if needed down the road.

 

[Fluff]

You're welcome.