Export 2 tabs into 2 tabs in a new file

Hello,

I have an Excel file with, let's say, 10 tabs: Template1, Template2, Template3 etc, with similarly structured data in all of them.

I need users to be able to export it to another file. Right now I have code that exports Template1 into Template1 tab in a new file. What I'm struggling with is to how to modify it to let users to export 2 tabs: so Template1 and Template2 from existing file, to Template1 and Template2 in the new file. Here is the code. Thank you so much in advance!!!!

Please Login or Register  to view this content.

Thanks Mumps1! It's almost what I wanted. The only problem is that it copies all tabs. So if I have Main, Template1 and Template2, it copies all 3 into the new file. But I only want Template1 and Template2, not Main. Does that makes sense? Thank you again!!!

Sorry, I was a little off. If I have Main, Template1 and Template2, it creates Sheet1,Template1 and Template2. Is there a way not to have Sheet1? Thanks again!!!

That worked! Thanks so much!!!