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-
Bookmarks