Copying and looping data from one file to another
Closed
dhunited12
Blocked Profile - Jun 11, 2018 at 05:19 PM
- Posts
- 1
- Registration date
- Monday June 11, 2018
- Status
- Member
- Last seen
- June 11, 2018
Blocked Profile - Jun 11, 2018 at 05:19 PM
Related:
- Copying and looping data from one file to another
- Easeus data recovery zip file download - Download
- How to recover deleted outlook data file - Guide
- Vip collection all vip emote data file.zip download - Guide
- Wd external hard drive not copying files ✓ - Forum - Hard Drive/SSD
- Files corrupted when copied to flash drive ✓ - Forum - Pen Drive/USB Key/SD Card
1 reply
So if we think about it, we really want tab one to be copied, not moved.
OK, I just recorded a macro and its output was:
SO there is the file save step.
I did all of this by recording the two macros you described. Now just, polish it up with variable to make it dynamic!
Sheets("Sheet1").Select
Sheets("Sheet1").Copy After:=Sheets(1)
OK, I just recorded a macro and its output was:
ActiveWorkbook.SaveAs Filename:="C:\Users\User\Documents\filenamehere.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
SO there is the file save step.
I did all of this by recording the two macros you described. Now just, polish it up with variable to make it dynamic!