Saving Multiple Tabs as New Excel File

All,

I am trying to automate some reports that I regularly generate. I am currently squeezing all of my data on 1 tab for each file I create using:

Please Login or Register  to view this content.

I'd like to split my data on to multiple tabs so that I can have a summary tab and a detail tab. In my master file that I'm working on, I have 30 worksheets to create 30 workbooks. I'd like to revise my master file to have 60 worksheets saving 2 worksheets to each file and still create 30 workbooks. Does that make sense?

Thank you!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here