Hi there. I have done a very similar project in Excel, using VBA, before and I can manage it for you pretty comfortably. I have in fact a few more ideas to improve the overall procedure. Kindly revert back and discuss, if you are interested.
Regards.
Usman.