I need to create a macro/vba code to copy two worksheets to a new workbook. These two worksheets have calculations on it so I need copy and paste these worksheets as values in a new workbook. But I want to keep the formatting of the worksheets the same. And I also need to name this new workbook a certain name. Can anyone shed some light on how I might do this?