Copy / Paste / Save As - Automation Help Needed

File I have : template.xml , 1.xml, 2.xml, 3.xml, ....., 100.xml, blank.xml

File I want to end up with 100 files : ~cell value in A2~.xml for each of 1.xml, 2.xml, 3.xml, ....., 100.xml

---

1) I need to 'copy' a cell range AQ1 to CD78 (box 1) from file template.xml

2) I then need to 'paste' at cell BA2 in file 1.xml. I need to 'copy' this (box 2) - (which is made up of rearranged values pulled from other cells in 1.xml).
The exact cell range of box2 in 1.xml is BA2 to CJ79. Again, I need to 'copy' this (box 2).

3) The next step is now to 'paste special - only values' at cell A1 in file blank.xml and 'Save-As' file name = ~cell value in A2~.xml

4) Rinse and Repeat Steps 1-3 but for files 2.xml,3.xml,4.xml,5.xml,....,100.xml

5) I should end up with 100 xml files : ~cell value in A2~.xml for each of 1.xml, 2.xml, 3.xml, ....., 100.xml

How Can I automate this process without having to do it manually?

Thanks for your help!

-Panos-

Can anyone help me with this?

If this is possible, it most likely requires VBA. I'd repost your thread on that forum.