Hello,
I can do that. In fact I have written the basic code, it has to be adjusted of course to your specific needs.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer of Excel and VBA for 12+ years. As you can guess, I have created a plethora of similar macros, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini