Hi

Thank you Fotis for replying so quickly.

That is what I am trying to achieve but rather than create a new worksheet I would like it to create a new workbook - can the code be tweeked to do this?

Ideally I would like the files to be saved directly to here:
P:\Test\Finance\manacc\MAN_ACC\Test2\2014\Mth0214\Transactional Reports\Hygiene

If that path doesnt already exist then I would like it created.

Could the file names be automatically defined e.g. "Transactional Report and the branch number (from column A) and the Month (I can define this in the macro each month)