Hello All,
I am using Excel 2013 and I have a Workbook where I have a Sheet name "Notes"
I want to copy this sheet as the last sheet in all the workbooks in a folder in the following path.
"C:\Username\Macro\Test\"
I got the code on this group from the year 2008 but it does not copy the Notes sheet in any of the workbook in the given path.
This is the link to the thread.
I changed xls to xlsx, the sheet name from "add" to "Notes" and the path accordingly but it still does not copy the "Notes" in all the workbook.
Any help in modifying the existing code or a new code would be greatly appreciated.
Note: Both the codes in the above thread does not work
TIA
I am using Excel 2013 and I have a Workbook where I have a Sheet name "Notes"
I want to copy this sheet as the last sheet in all the workbooks in a folder in the following path.
"C:\Username\Macro\Test\"
I got the code on this group from the year 2008 but it does not copy the Notes sheet in any of the workbook in the given path.
This is the link to the thread.
macro/code to insert specific sheet into all workbooks in folder
I have a specific Worksheet set up as a formatted "template" and want to add it to every file/workbook in a specific folder. Each of these files only contains Sheet1 and the 'template' is named "add". Is there an easy way to do this?
www.mrexcel.com
I changed xls to xlsx, the sheet name from "add" to "Notes" and the path accordingly but it still does not copy the "Notes" in all the workbook.
Any help in modifying the existing code or a new code would be greatly appreciated.
Note: Both the codes in the above thread does not work
TIA