Merging 2 files, but not merging sheets

[Jen206]

I am having trouble figuring out a way to take 2 separate files with 1 sheet each to be combined into a master file with 2 sheets. Ideally the files would be in separate folders but they could be put in the same file if it would be easier.

I have very basic VBA knowledge/experience and its giving me a headache! Any help would be appreciated!

 

[Trevor G]

Welcome to the Forum.

You can open both files then using the tabs at the bottom select right mouse button and select Move Copy and then create a copy to new book, do that for each book and its done, if you want VBA then look to Record a macro whilst you do this.

 

[Jen206]

True, I should of speciifed thatl I have like 3000+ files that I want to join. So copy and pasting each individual one would take too long...

I have 3000 of file type A by Item and over 3000 of file type B by item, so I want to join the to sheets A & B's together into a single file by item...