Copy data from one file to an other file

Hello,

I have to copy 120 sheets per month for some months from one WB to a second one. The shape of the area is the same: F5:AC66.

At first glance the operation may seems useless, but it is necessary due to a new system of calculation and it seems the best choice to me to copy the data from the sheets with the ancient formulas to the sheets with the new formulas.
Beside the action of copying the macro has also to create a sheet in the destination WB for every sheet in the source WB that doesn't exist yet and to put the name of the sheet into the cell U1 of every sheet.
There are 3 sheets that don't have to be copied: DoNotCopy 1 to 3.
How should the code look like which could do the required performance?
Kind regards

AmicusA

Place this macro in a regular module in the source workbook. Make sure both files are open and run the macro. We may have to make some minor changes to it to get exactly what you want.

Please Login or Register  to view this content.

Hi,

Thank you very much for the code.
It works fine, but at the end I still have the data with the ancient formulas, whereas the purpose of the whole operation is to get the data into new destination sheets based on the Modelsheet with the new formulas.
The macro would be better settled in a third WB, like that one attached. In the real third WB that contains the macros I have a sheet "Switch" with a lot of buttons.
Kind regards
AmicusApis

Putting the macro in another workbook is not a problem. When you say "ancient formulas" and "new formulas" I don't really know what you are referring to. I don't see any formulas in either workbook. Please clarify in detail.