Hello,
In fact macros can be created and other calculations can be complete in max 1 day. I'm developing VBA programs for more than 15 years and I'm a VBA and Excel trainer (all levels) 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