Excel VBA Macro to tidy up spreadsheet

Job ID: 34334223

Budget: £10 – £20 GBP

I have an excel report that contains data for a number of projects for a number of months

However the report is set up so that when a project contains 0 cost for a month, it does not create a column with zeroes, it simply does not create a column.

I would like a macro that will loop through all of the projects and find the project with the most monthly columns, and ensure all projects replicate this structure.

The macro should also add totals to the total rows at the bottom of each project.
Related categories: Visual Basic Excel