Thank you, this worked perfectly!
And do I have to change the source workbook/destination workbook name in the macro after each experiment I run or is there a way this can be automated?
Thanks again for the help and patience.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.