I posted something similar, but didn't receive any replies, so wonder if my explanation was not very good. I've spend the last few hours searching for a solution to this problem, but to no avail. Many options that are close, but none that match!
Folder 1 has 50 WorkBooks in it, Folder 2 has another 50 WorkBooks in it (which I can put into Folder 1 if that makes things easier). Each Workbook contains a single sheet. I need a macro that will allow me to select two WorkBooks (not all the WorkBooks in the folder) and then combines them into a new WorkBook with two Tabs, maintaining the sheet names from each WorkBook. I need to try and automate the process as I have literally several hundred WorkBooks to combine!
In a perfect world I would like the macro to also be able to automatically save the new file to a user definable folder, giving it filename based on the content of a cell in the new WorkBook. Is this possible to do?
I've looked at lots of examples and also tried the RDBMerge Add in, but none do the above.
If the file saving complicates things, I could do this manually, but I'm try to automate the process as fae as possible owing to the volume of files and the frequency with which this needs to be done.
Many thanks
Bookmarks