Hi,
I have checked your project description and the attached file. I will able to design the macro to achieve this goal for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please allow me this to work with you on this project.
I always deliver high quality work with full customer satisfaction.
Thanks and regards,
Mohan