| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create different workbooks from a single worksheet
Hi,
I have data in a worksheet, in which the main distinguisher is the manager name. I want to create different files for each manager. How can this be done. Thanks fari |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create different workbooks from a single worksheet
Could you please describe the layout of your data in more detial? e.g. Are
the Manager names "Column headings" or they are data which appear multiple times in a particular column? Regards, Edwin Tam http://www.vonixx.com "fari" wrote: Hi, I have data in a worksheet, in which the main distinguisher is the manager name. I want to create different files for each manager. How can this be done. Thanks fari |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create different workbooks from a single worksheet
Thanks for the response. The Manager name is a col heading and then
there are several managers in that col. Thanks fari |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create different workbooks from a single worksheet
You may want to look at Ron de Bruin's code:
http://www.rondebruin.nl/copy5.htm fari wrote: Hi, I have data in a worksheet, in which the main distinguisher is the manager name. I want to create different files for each manager. How can this be done. Thanks fari -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging single worksheet files into a single workbook | Excel Discussion (Misc queries) | |||
| Consolidate multiple workbooks into a single worksheet | Excel Worksheet Functions | |||
| Save a single worksheet in Excel as a single file. | New Users to Excel | |||
| create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
| Multiple Workbooks to a Single Sheet | Excel Programming | |||
Linear Mode
