Hi there,

I know how to do this using copy, paste special, values only... but I would like to automate it if possible as it is going to come up a lot.

Any help much appreciated.

Regards
Chris