One Workbook for Each Worksheet

[Lilbit]

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!!

 

[Ron de Bruin]

Hi Lilbit

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