if then statement help
 

Hello-

I have the following info in excel and I need code to place an "X" in
column J if the conditions are met, then continue searching down the
sheet for similar instnaces and dropping X's in column J where
appropriate.

A B C D
E F G H J
RING 532 0 n n n n
ACD IN 532 254 n n n n
AVAIL 0 0 n n n n
RING 532 0 n n n n
ACD IN 532 3 n n n y

IF Range("h5").value = "y" AND Range("d5").value < 10 AND
range("a4").value = "ring" Then .Range("j5").value = "X"

Thanks-

Scott

if then statement help
 

If that's all there is to it, the following should do:

Sub X()

If Range("H5").Value Like "y" And Range("D5").Value < 10 And _
Range("A4").Value Like "RING" Then Range("J5").Value = "X"

End Sub

"Sabosis" wrote:

Hello-

I have the following info in excel and I need code to place an "X" in
column J if the conditions are met, then continue searching down the
sheet for similar instnaces and dropping X's in column J where
appropriate.

A B C D
E F G H J
RING 532 0 n n n n
ACD IN 532 254 n n n n
AVAIL 0 0 n n n n
RING 532 0 n n n n
ACD IN 532 3 n n n y

IF Range("h5").value = "y" AND Range("d5").value < 10 AND
range("a4").value = "ring" Then .Range("j5").value = "X"

Thanks-

Scott