Saving input into 2nd worksheet while keeping the 1st empty
Closed
BritanyWorkwood
Posts
1
Registration date
Sunday July 23, 2017
Status
Member
Last seen
July 23, 2017
-
Jul 23, 2017 at 07:20 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 25, 2017 at 11:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 25, 2017 at 11:52 AM
Related:
- Saving input into 2nd worksheet while keeping the 1st empty
- Transfer data from one excel worksheet to another automatically - Guide
- 1st mass mailer - Download - Email
- Power saving mode in computer - Guide
- Input phone lock code sos ✓ - Phones, PDA & GPS Forum
- How to input @ in laptop - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Updated on Jul 25, 2017 at 11:55 AM
Updated on Jul 25, 2017 at 11:55 AM
Hi Britany,
Important note:The code below both deletes data and saves your workbook. So make sure you test this with a copy of your workbook !!!
Here is the code:
Since you gave me a spoiler, let me provide some extra info on using codes:
How to implement and run a code:
- From Excel hit Alt + F11 to open the “Microsoft Visual Basic” window.
- Go to the top menu in the newly opened window > Insert > Module.
- Paste the code in the big white field.
- You can now close this window.
- Back at Excel, hit Alt + F8 to display the available macro’s.
- Double-click the macro you wish to run.
NOTE: macro’s cannot be reversed using the blue arrows. Always make sure you save your file (or create a back up to be entirely sure) before running a code, so you can re-open your file if something unforeseen happens or you want to go back to the situation before the code was run.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Important note:The code below both deletes data and saves your workbook. So make sure you test this with a copy of your workbook !!!
Here is the code:
Sub RunMe() Sheets("Checklist").Cells.Copy Sheets.Add after:=Sheets(Sheets.Count) ActiveSheet.Name = "Checklist " & Date Range("A1").PasteSpecial Sheets("Checklist").Select Range("B2:B" & Range("B1").End(xlDown).Row).ClearContents ActiveWorkbook.Save End Sub
Since you gave me a spoiler, let me provide some extra info on using codes:
How to implement and run a code:
- From Excel hit Alt + F11 to open the “Microsoft Visual Basic” window.
- Go to the top menu in the newly opened window > Insert > Module.
- Paste the code in the big white field.
- You can now close this window.
- Back at Excel, hit Alt + F8 to display the available macro’s.
- Double-click the macro you wish to run.
NOTE: macro’s cannot be reversed using the blue arrows. Always make sure you save your file (or create a back up to be entirely sure) before running a code, so you can re-open your file if something unforeseen happens or you want to go back to the situation before the code was run.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.