How do I create a new work book with selected worksheets

=?Utf-8?B?QnJpYW5X?=

Guest

Posts: n/a

26th Jun 2007

I have about 25 worksheets in one workbook. These are linked to a summary
sheet of approx 2500 lines. I want to created a “homepage” where I can
select say 5 of the worksheet and create a new book with just the five sheets
and the summary sheet. Would someone be willing to share the code that would
allow me to do what I’m looking to do?
I’d greatly appreciate any assistance!
PS I'm a real novice at this

Brian

« formula and offset | Listbox has some items selected when userform containing it opens. »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How Do I Tie Worksheets to one Work book?	Bettine S Cavanaugh	Microsoft Excel Worksheet Functions	2	31st Mar 2008 04:01 AM
Macro to work only on selected worksheets	Skihde@yahoo.com	Microsoft Excel Misc	2	22nd Jan 2007 07:14 PM
How can I sort worksheets in a work book?	=?Utf-8?B?UGF1bEdlZQ==?=	Microsoft Excel Worksheet Functions	1	29th Sep 2004 03:28 PM
In Excel create index on first sheet of selected worksheets	=?Utf-8?B?S2VuIE0=?=	Microsoft Excel Worksheet Functions	1	1st Sep 2004 08:07 AM
Create individual worksheets for selected rows in a table	Batman2002	Microsoft Excel Discussion	4	16th Oct 2003 05:44 PM