Insert row on diff sheet IF
 

On sheet "NF", IF C2=2 and C3=1, then I would like a blank row inserted on
sheet "BK" at row 39. If those two conditions are not met, then Do Nothing.
IF the conditions are met and the row is inserted, then I would like C39 on
"BK" to have "DCD" entered into it and "RN" placed in cell G39.

Thanks in advance!

Insert row on diff sheet IF
 

Hope this helps-

Sheets("NF").Activate
If Range("C2").Value = 2 And Range("C3").Value = 1 Then
Sheets("BK").Activate
Range("A39").Insert xlDown
Range("C39").Value = "DCD"
Range("G39").Value = "RN"
End If

--
Pranav Vaidya
VBA Developer
PN, MH-India


"Tom" wrote:

On sheet "NF", IF C2=2 and C3=1, then I would like a blank row inserted on
sheet "BK" at row 39. If those two conditions are not met, then Do Nothing.
IF the conditions are met and the row is inserted, then I would like C39 on
"BK" to have "DCD" entered into it and "RN" placed in cell G39.

Thanks in advance!

Insert row on diff sheet IF
 

Thanks Pranav!

"Pranav Vaidya" wrote:

Hope this helps-

Sheets("NF").Activate
If Range("C2").Value = 2 And Range("C3").Value = 1 Then
Sheets("BK").Activate
Range("A39").Insert xlDown
Range("C39").Value = "DCD"
Range("G39").Value = "RN"
End If

--
Pranav Vaidya
VBA Developer
PN, MH-India


"Tom" wrote:

On sheet "NF", IF C2=2 and C3=1, then I would like a blank row inserted on
sheet "BK" at row 39. If those two conditions are not met, then Do Nothing.
IF the conditions are met and the row is inserted, then I would like C39 on
"BK" to have "DCD" entered into it and "RN" placed in cell G39.

Thanks in advance!