Excel VBA Macro to tidy up spreadsheet
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.
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.