Hello Alastair

Thank you for your help on this macro. The information in F3:Z60 is set to be removed by a month end macro leaving all the current information in cells A3:E60, AA3:AB60 and AD3:AN60 needing to be sorted. AC will always be blank.


I'll have a play on this shortly and will let you know how I get on :-)