I am trying to setup a macro that will take my original file that includes multiple sheets and split it into multiple workbooks with the same sheets based on a name entered into a column on the first (main) sheet. I have been able to create a macro that will create multiple workbooks for one sheet but not for multiple sheets (see below). The main worksheet will contain unique data, but the other worksheets will just need to be copied to the new workbooks. I also need any links on the main worksheet to remain intact (linked to other sheets within the workbook as opposed to linking to the original workbook). Pleaee help if you can. Thank you.
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks