Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |