Related:
- How to insert rows in excel based on cell value
- INSERT ROW DATA INTO EVERY SECOND ROW ✓ - Forum - Excel
- How to insert rows in excel automatically based on cell value - Forum - Excel
- Copy rows to another sheet based on specific cell value in microsoft excel ✓ - Forum - Excel
- Excel Macro to insert row based on data ✓ - Forum - Excel
- Macro to insert row in excel based on criteria ✓ - Forum - Excel
2 replies
TrowaD
- Posts
- 2691
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 14, 2021
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:
Best regards,
Trowa
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
TrowaD
- Posts
- 2691
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 14, 2021
Hi Lack,
My guess would be that you selected more then one cell when changing column D. This could happen when clear data from multiple cells.
To prevent this you can add the following code line between the 2nd and the 3rd code line:
If Target.Cells.Count > 1 Then Exit Sub
Does that help?
Best regards,
Trowa
My guess would be that you selected more then one cell when changing column D. This could happen when clear data from multiple cells.
To prevent this you can add the following code line between the 2nd and the 3rd code line:
If Target.Cells.Count > 1 Then Exit Sub
Does that help?
Best regards,
Trowa
Subscribe To Our Newsletter!
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!!!
- Posts
-
2691
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 14, 2021
454The 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