Hi, I can help you with this task. I think you can work this out with formulas, no need for macros.
I have experience in excel and I am very quick and effiient. I worked the past 10 years in global companies, mainly in financial areas, so I have lot of experience in managing data, building reports and KPIs, etc.
Hope we can work together,
Maria