PC Review


Reply
Thread Tools Rate Thread

Copy selected mulitple worksheets to mulitple new workbooks

 
 
=?Utf-8?B?SWFu?=
Guest
Posts: n/a
 
      8th Mar 2007
I have a master workbook with several worksheets, some of which I want to
copy to new workbooks based on a table within the original workbook

So for example, I have worksheets TSheet1, TSheet2 .... TSheet8 in a
workbook, and arelisted in a table together with the name of the NewWB that I
want them copied to ..for example :

TSheet1 NewWB_01
TSheet2 NewWB_01
TSheet3 NewWB_02
TSheet4 NewWB_03
TSheet5 NewWB_01
TSheet6 NewWB_03
TSheet7 NewWB_02
TSheet8 NewWB_01

So the result should be 3 new workbooks NewWB_01, NewWB_02, NewWB_03 which
will each contain copies of the worksheets per the above list.

The number and names of both worksheets and new workbooks will need to vary
( I have simplified them in the above example)

--
Regards & Thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy sheets to mulitple workbooks in a directory Greg Microsoft Excel Programming 2 31st Mar 2009 12:22 PM
Copy/ move selected data from workbooks to seperate worksheets or workbooks Positive Microsoft Excel Worksheet Functions 1 30th Aug 2007 04:54 PM
Macro to Copy Mulitple Worksheets to New Multiple Workbooks =?Utf-8?B?SWFu?= Microsoft Excel Programming 8 13th Mar 2007 05:16 PM
RE: Copy selected mulitple worksheets to mulitple new workbooks =?Utf-8?B?VmVyZ2VsIEFkcmlhbm8=?= Microsoft Excel Programming 0 8th Mar 2007 06:57 PM
link to mulitple workbooks =?Utf-8?B?dmlvbGV0?= Microsoft Excel Programming 2 20th Nov 2006 06:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:49 PM.