Hi gurus,
Thanks in advance to anyone who takes the time to respond!
I'm trying to create a macro which will loop through each sheet in a workbook called 'Syndication_Macro.xlsm' and copy the sheets to other workbooks.
The folderpath is the same for each workbook and the workbooks are named after the sheets to be exported. i.e.
Sheet 1 should be exported to:
"C:\Syndication\Sheet1.xlsx"
Sheet 2 should be exported to:
"C:\Syndication\Sheet2.xlsx"
etc. etc.
I haven't had much luck by myself so would appreciate any help!
Bookmarks