Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default One Workbook for Each Worksheet

Here's a doozy: I have a workbook with 12 worksheets. I need to make a
workbook for each worksheet. Each workbook will be named similarly with
the officer's name added in parentheses; (i.e., Workbook1:
Accts12-31-07(George); Workbook2: Accts12-31-07(Hanson)). Is this
possible. Thanks!!

--
Message posted using http://www.talkaboutsoftware.com/gro...eet.functions/
More information at http://www.talkaboutsoftware.com/faq.html

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default One Workbook for Each Worksheet

Hi Lilbit

Try this example
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lilbit" wrote in message lkaboutsoftware.com...
Here's a doozy: I have a workbook with 12 worksheets. I need to make a
workbook for each worksheet. Each workbook will be named similarly with
the officer's name added in parentheses; (i.e., Workbook1:
Accts12-31-07(George); Workbook2: Accts12-31-07(Hanson)). Is this
possible. Thanks!!

--
Message posted using http://www.talkaboutsoftware.com/gro...eet.functions/
More information at http://www.talkaboutsoftware.com/faq.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Data from Workbook into specific Worksheet in other Workbook? kingdt Excel Discussion (Misc queries) 1 March 16th 06 06:55 PM
Link worksheet totals to a summary worksheet in the same workbook Carolyn Excel Worksheet Functions 0 March 3rd 06 04:36 PM
Copying A Worksheet From Each Open Workbook to an new Workbook carl Excel Worksheet Functions 1 January 3rd 06 05:37 PM
How can I link cell colours from worksheet to worksheet/workbook? Evelyn Excel Worksheet Functions 1 July 5th 05 09:16 PM
copy worksheet from closed workbook to active workbook using vba mango Excel Worksheet Functions 6 December 9th 04 07:55 AM


All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"