Copying a row to another sheet with a trigger
Closed
Zav
-
Jan 20, 2015 at 01:11 AM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Copying a row to another sheet with a trigger
- Excel - Copying row from another sheet - How-To - Excel
- Excel if cell contains text then copy row to another sheet ✓ - Forum - Excel
- Excel move row to another sheet based on cell value without macro ✓ - Forum - Excel
- Copying data from one excel sheet to another - Guide
- Excel copy rows from one sheet to another based on criteria ✓ - Forum - Excel
1 reply
TrowaD
Jan 22, 2015 at 10:45 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Jan 22, 2015 at 10:45 AM
Hi Zav,
First create a button:
Developer ribbon > insert > command button (ActiveX)
Right-click the button and select View code.
Paste the following in between the two already existing code lines:
Best regards,
Trowa
First create a button:
Developer ribbon > insert > command button (ActiveX)
Right-click the button and select View code.
Paste the following in between the two already existing code lines:
Dim Check As String Check = MsgBox("The selected row will be copied to the 'Visited' sheet.", vbOKCancel, "Copying row") If Check = vbCancel Then Exit Sub Selection.Copy Sheets("Visited").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
Best regards,
Trowa