Copy selected sheets to new book

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

Hello
How can I copy selected sheets and move them to a new book as values only?
Thanks!
 
Record a macro whilst copying the sheets you select by CTRL + click then
Right-click and "Move or Copy">Create a copy to New book.

When copied, select all sheets in new book and select all cells on active sheet
then Copy>Paste Special>Values>OK>Esc.

Right-click and "Ungroup Sheets".


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Copy worksheet, trying to paste to new workbook error assistance. 1
Excel Protection 2
Copy and paste sheets to new workbook 14
Copy Sheets to new Book 3
Copy Sheet Into New Workbook 1
Disable "Move or Copy sheet "action 1

Back
Top