Thank you very much for that Pierre, as someone who knows nothing about macros you explained it very well and it seems to be working fine. You do raise a good point about the date though!

Typically I'd update the report every week with a Friday cut-off. If I were to put the Friday cut-off date in cell B2, how would you modify the code you sent to make provision for that?

Thanks once again.