Hello,
It's an easy job for me, in fact VBA macro will be ready and tested in a few hours. Of course I need to know which cells you want to copy and where in the target file.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a VBA and Excel trainer for 12+ years. As you can guess, I have written a plethora of macros of any kind, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini