Excel Macro or VBA-Copy All Sheets to Paste Values/Formats to new book

[Scott02]

I'm hoping someone has something that already works, or it's a simple thing to set up. I have a file with multiple tabs and a lot of sumif formulas that cause the pc to struggle. I need to send these reports (active sheets only) to other people, but want to send only values/formats. Is there a way to copy multiple sheets from one file, and paste values and formats to a new workbook with a single step? I appreciate your time!

 

[SkipVought]

hi,

Turn on your macro recorder and record

1) adding a new workbook

2) COPY the contents on ONE SHEET

3) Edit > Paste Special that ONE SHEET into a sheet in the new workbook.

4) Save the new workbook with the approciate name.

Turn off the macro recorder.

Post this question AND the macro you recorded in forum707 for a VBA solution.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]