Sorry about the delay. I have now replicated the data in original form - and then the desired output.
Couple of things to note;
This macro will be run each month
The number of rows will be different each month (could be less, could be more)
The Macro will start on another tab/sheet
It will need to run on sheet "A-L" & "M-Z"
Thanks again! I'm sure the solution is simple
Bookmarks