I am proficient with excel macro/VBA development, I can write the macro to generate requested report as attached, I am ready to start your project right away, if you are interested feel free to message me, looking forward to chat further and work on your project