Greetings everyone,

Recently I have come across the laborious task of copying specific content from a word file and pasting them in specific places on another word file. This is an activity where an organization is updating the format of their SOPs. I have the new template and I also have the old SOP files. However these are 200-300 in number and doing this task manually would consume too much time. Is there a way to automate this task using Macro and VBA?

Sequence of actions:
1. Open template file.


2. Open old SOP file.
3. Copy specific data from the SOP file.
4. Paste the data to specific places in the template file (this includes headers).
5. Save as the template file giving it the same name as the SOP file with a "new" at the end.
6. Repeat the action 200 times.

It could be amazingly helpful if I can just select a folder containing all the old SOP files and after running the code, it creates a new folder with new files on the new format.

Any and all tips and suggestions would be highly appreciated.