Good morning everyone - I have a workbook (new one is sent each month) with about 50 tabs that need to be separated into new workbooks (50 workbooks) every month!
Is there a macro that can be set-up to do this? I found the one below online but it didn't seem to work. The names of the workbooks would be the names of the tabs.
HTML Code:
Bookmarks