We are currently using a tool, that generates a complex excel reports.
We are interested in writing a macro, that simplifies the reports.
See the attached zip file, it has a sample input and output files.
The excel macro should take the Input file and produce the output file.
Please show excel macro prototypes to win the work.