September 6th, 2012, 10:13 AM
Join Date: Nov 2003
Time spent in forums: 6 h 33 m 3 sec
Reputation Power: 11
I believe this is simple enough to automate, but I need help penning the code.
I have a series of Excel files, one for each calendar year.
And I want them all to have the exact same header line that is in another file (headers.xlsx).
The headers are to overwrite the header line that’s already in each file.
So, from “headers.xlsx” I want A1 through BE1 pasted into those same cells in each calendar year file.
Can this be done?
Thank you for any help,