| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy multiple sheets to seperate workbooks
I have a file with 200 sheets for different sales people. I want to send them
their sheet only and want to copy the sheets into their own files. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy multiple sheets to seperate workbooks
There are a few ways
Install one of the templates in the file http://www.rondebruin.nl/mail/templates.htm Or if you have the mail address in each worksheet you can use http://www.rondebruin.nl/mail/folder1/mail5.htm Or http://www.rondebruin.nl/mail/folder2/mail5.htm If you want to create first seperate workbooks see http://www.rondebruin.nl/copy6.htm And then you can use this macro to mail http://www.rondebruin.nl/mail/folder2/files.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MY" wrote in message ... I have a file with 200 sheets for different sales people. I want to send them their sheet only and want to copy the sheets into their own files. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I group or link sheets in seperate workbooks? | Excel Discussion (Misc queries) | |||
| Seperate data from one sheet to multiple sheets based on a column | Excel Discussion (Misc queries) | |||
| Splitting data from sheets into seperate workbooks based on formul | Excel Worksheet Functions | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| how do I open multiple excel workbooks in seperate windows? | Excel Discussion (Misc queries) | |||
Linear Mode
