All,
Thank you for your help. I am trying to get a macro to generate reports for me, and save different tabs as different files. My macro will currently save EVERY tab as a new file, but I now want to spread out my data to be easier to read, so I'd like it to save every 2 tabs as a new file. I've attached a sample spreadsheet with my macro saved to it (note that the numbers were made up by me just now). I'd like to get the new macro to save the first two tabs as 1 file, and the second 2 tabs as another file. The code I'm currently using to save tabs as files is:
Any help you can give me would be greatly appreciated.Please Login or Register to view this content.
Thanks!
Bookmarks