Could an expert help me out with this one please
I have attached a file that has sheet 1 and sheet 2. Think of sheet 1 as the starting point and sheet 2 after the code has bee run.
Each day the report is run and each day I need to add a new column to the right of the last day working days data. So on sheet 1 you will see there are 3 days 1/4, 2/4 and 3/4
So today I need VBA code that will insert today to the right of 3/4 and include all of the conditional formats that are in the cells. I also need there to be 3 blank columns between the last day and the column headed 'Type'
Sheet 2 is what I need it to look like after the Macro has run.
I hope that explains it clearly.
Thanks in advance