Need VBA code to Keep adding data from 2 specific cells
Closed
balas182005
Posts
1
Registration date
Tuesday November 19, 2013
Status
Member
Last seen
November 19, 2013
-
Nov 19, 2013 at 12:49 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 21, 2013 at 10:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 21, 2013 at 10:59 AM
Related:
- Need VBA code to Keep adding data from 2 specific cells
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- How to get whatsapp verification code online - Guide
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Samsung keypad reset code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 21, 2013 at 10:59 AM
Nov 21, 2013 at 10:59 AM
Hi Balas,
On sheet2 I put a header in A1 (Name), B1 (Address).
On sheet1 I added a button and named it cmd_Save.
Then attached the following code to the button:
Best regards,
Trowa
On sheet2 I put a header in A1 (Name), B1 (Address).
On sheet1 I added a button and named it cmd_Save.
Then attached the following code to the button:
Private Sub cmd_Save_Click()
Range("C7").Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
Range("C9").Copy Sheets("Sheet2").Range("B" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub
Best regards,
Trowa
