Hi all, I'm working on a current workbook ('Workbook1') where I would like to copy only the used range data from 'Sheet1', starting from cell A2 (ignoring headers).
I would then like to open a separate, closed workbook ('Workbook2'), go to 'Sheet2', delete rows 2-10 (leaving headers), and paste (values only) the used range of 'Sheet1', 'Workbook1' into cell A2 of 'Sheet2', 'Workbook2'.
Workbook2 path = "S:\Folder1\Folder2\Workbook2.xlsx"
The name and path of Workbook2 will always be the same
I would then like to save 'Workbook2' (SaveAs) using file name "Upload File" & Format (Now, "dd-mm-yy hh.mm") & ".xlsx", into "Folder3" of the same path above. Close/save the newly created "Upload File" and then close the original 'Workbook2' without saving any changes.
Any help would be appreciated. Thanks.
I would then like to open a separate, closed workbook ('Workbook2'), go to 'Sheet2', delete rows 2-10 (leaving headers), and paste (values only) the used range of 'Sheet1', 'Workbook1' into cell A2 of 'Sheet2', 'Workbook2'.
Workbook2 path = "S:\Folder1\Folder2\Workbook2.xlsx"
The name and path of Workbook2 will always be the same
I would then like to save 'Workbook2' (SaveAs) using file name "Upload File" & Format (Now, "dd-mm-yy hh.mm") & ".xlsx", into "Folder3" of the same path above. Close/save the newly created "Upload File" and then close the original 'Workbook2' without saving any changes.
Any help would be appreciated. Thanks.