Hi Anilkarthik,
If I understand you correctly, you want to copy row from sheet1 to sheet2 whenever "RC" is entered in Column D.
To do so, right-click sheet1's tab and select view code. Paste the code below in the big white field:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("D:D")) Is Nothing Then Exit Sub
If Target.Value = "RC" Then
Target.EntireRow.Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End If
End Sub
Best regards,
Trowa
If Target.Value = "RC" Then
I am not able to troubleshoot how to fix this. Any help would be greatly appreciated!
there is a drop down box on the upper right hand side with options such as activate, change, calculate, deactivate, etc
thanks in advance for your assistance!!!
The code will run automatically. So after pasting the code go back to Excel and enter the value "RC" anywhere in column D and the row will be copied to sheet 2, if you haven't altered the code.
Best regards,
Trowa