Code is installed in "Module1": instructions below (for EACH workbook)

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
[B][I]


RUN button does everything. Ensure there is a "Data" tab in each workbook.

Month is in cell A1 (as per sample). Just change this BUT it must the same as on the tabs. I recommend you use "Jan","Feb" etc as the months


You can/add delete rows at will BUT do NOT put any other data below those data columns: it is bad practice.


AND as previously requested, PLEASE remove all confidential data from files posted to this forum. I would remove all the files you have posted on this thread. I will remove the ones I posted.