Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create multiple workbooks from a single Excel spreadsheet
Can someone help me with a Macro to create multiple workbooks from a
single Excel spreadsheet?The data on the spreadsheet is similar to the following: A B C DEPTA XXXX YYYY DEPTA AAAA BBBB DEPTA DDDD RRRR DEPTB SSSS TTTTT DEPTB XXXXX AAAA DEPTC AAAA BBBB DEPTC JJJJJJ LLLLLL .. .. .. .. I would like to create a new workbook with all of the rows for DEPTA in it, another workbook with all of the rows for DEPTB in it, another workbook with all of the rows for DEPTC in it, etc. If possible, I would like the name of each new workbook to begin with the value in column A. For example, DEPTAmmddyy.csv, DEPTBmmddyy.csv, etc. Thanks for any suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create multiple workbooks from a single Excel spreadsheet
Hi slowjam4
Try this http://www.rondebruin.nl/copy5.htm Use this example http://www.rondebruin.nl/copy5.htm#workbook If you need more help post back -- Regards Ron de Bruin http://www.rondebruin.nl "slowjam4" wrote in message oups.com... Can someone help me with a Macro to create multiple workbooks from a single Excel spreadsheet?The data on the spreadsheet is similar to the following: A B C DEPTA XXXX YYYY DEPTA AAAA BBBB DEPTA DDDD RRRR DEPTB SSSS TTTTT DEPTB XXXXX AAAA DEPTC AAAA BBBB DEPTC JJJJJJ LLLLLL . . . . I would like to create a new workbook with all of the rows for DEPTA in it, another workbook with all of the rows for DEPTB in it, another workbook with all of the rows for DEPTC in it, etc. If possible, I would like the name of each new workbook to begin with the value in column A. For example, DEPTAmmddyy.csv, DEPTBmmddyy.csv, etc. Thanks for any suggestions. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create multiple workbooks from a single Excel spreadsheet
Hi Ron,
Your solution worked perfectly. Thanks for your prompt reply to my question. On Dec 6, 3:20 pm, "Ron de Bruin" wrote: Hislowjam4 Try thishttp://www.rondebruin.nl/copy5.htm Use this examplehttp://www.rondebruin.nl/copy5.htm#workbook If you need more help post back -- Regards Ron de Bruinhttp://www.rondebruin.nl "slowjam4" wrote in ooglegroups.com... Can someone help me with a Macro to create multiple workbooks from a single Excel spreadsheet?The data on the spreadsheet is similar to the following: A B C DEPTA XXXX YYYY DEPTA AAAA BBBB DEPTA DDDD RRRR DEPTB SSSS TTTTT DEPTB XXXXX AAAA DEPTC AAAA BBBB DEPTC JJJJJJ LLLLLL . . . . I would like to create a new workbook with all of the rows for DEPTA in it, another workbook with all of the rows for DEPTB in it, another workbook with all of the rows for DEPTC in it, etc. If possible, I would like the name of each new workbook to begin with the value in column A. For example, DEPTAmmddyy.csv, DEPTBmmddyy.csv, etc. Thanks for any suggestions.- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a single workbook from multiple workbooks | Excel Discussion (Misc queries) | |||
macro: copy multiple workbooks to multiple tabs in single book | Excel Programming | |||
How to create different workbooks from a single worksheet | Excel Programming | |||
Excel 2003 Referencing multiple workbooks via single variable | Excel Worksheet Functions | |||
Multiple Workbooks to a Single Sheet | Excel Programming |