Hello,
I can certainly do that efficiently and fast. I can't say more, as I have no enough information to give you a complete description.
A few words about me: I'm developing VBA code for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have done similar tasks many times, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
chriskerpini