Using Command Button to post on another sheet!
Closed
cmedlar
Posts
1
Registration date
Wednesday November 4, 2015
Status
Member
Last seen
November 4, 2015
-
Nov 4, 2015 at 06:43 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 5, 2015 at 11:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 5, 2015 at 11:02 AM
Related:
- Using Command Button to post on another sheet!
- Attrib command - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- How to copy data from one sheet to another in excel automatically - Guide
- Rename computer command line - Guide
- Little alchemy cheat sheet - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Nov 5, 2015 at 11:02 AM
Nov 5, 2015 at 11:02 AM
Hi Colin,
This is the code line you are looking for:
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Range("A1").Value
How you use it depends on the type of command button you use (Using form > create module; Using activeX > paste line between the 2 existing ones).
Can you take it from here?
Best regards,
Trowa
This is the code line you are looking for:
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Range("A1").Value
How you use it depends on the type of command button you use (Using form > create module; Using activeX > paste line between the 2 existing ones).
Can you take it from here?
Best regards,
Trowa