Copy selected sheets to new book
 

Hello
How can I copy selected sheets and move them to a new book as values only?
Thanks!

Copy selected sheets to new book
 

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 CopyPaste SpecialValuesOKEsc.

Right-click and "Ungroup Sheets".


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 12:08:00 -0800, Al wrote:

Hello
How can I copy selected sheets and move them to a new book as values only?
Thanks!