Copy selected sheets to new book

's Computer Specifications

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

's Computer Specifications

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

On Thu, 31 Jan 2008 12:08:00 -0800, Al <(E-Mail Removed)> wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vb code to copy and list selected row to diff sheets	pvkutty	Microsoft Excel Misc	1	17th Feb 2010 12:05 PM
Copy Selected Sheets' Data On New Workbook!	Faraz A. Qureshi	Microsoft Excel Programming	0	15th Dec 2009 12:27 PM
Copy Sheets to new Book	Steve	Microsoft Excel Programming	3	26th Mar 2008 05:38 PM
Re: copy sheets selected on user form	Tom Ogilvy	Microsoft Excel Programming	0	19th Aug 2004 06:15 PM
Re: copy sheets selected on user form	Ron de Bruin	Microsoft Excel Programming	0	19th Aug 2004 06:03 PM