Hi, I'm a bit late on this. Can certainly do the macro/pivot table but have you considered "hard wiring" it with database formulas? I have worked on conversion, manipulation and analysis of Excel for 20 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. Example in PM. I am UK based, on GMT time, available on skype and a native English speaker. I would like to work on this project and I am available now. Regards, David