Macro to create a new workbook from a worksheet

Closed
simonrhi Posts 3 Registration date Thursday May 18, 2017 Status Member Last seen May 24, 2017 - May 18, 2017 at 03:49 PM
I would like to create a macro which copies all of the data and formatting from a worksheet into a new workbook with pasted values.