Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting worksheet into multiple workbooks
have a worksheet that contains multiple records that need to be grouped and
exported to a new workbook. Values to group by are in column a, so for example all of the records in column a with a value of 2011 need to go to a workbook named "2011.xls", all of the reocrds in column a with a value 3535 need to go to a new workbook named "3535.xls" etc. etc. I will be receiving this data weekly and need an automated way to split it up into distinct workbooks by value in column A Thank you in advance for your help. Regards, R- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting worksheet into multiple workbooks
Hi Rob
Here is a example that copy to new sheets You can adapt it for workbooks. If you need help post back http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... have a worksheet that contains multiple records that need to be grouped and exported to a new workbook. Values to group by are in column a, so for example all of the records in column a with a value of 2011 need to go to a workbook named "2011.xls", all of the reocrds in column a with a value 3535 need to go to a new workbook named "3535.xls" etc. etc. I will be receiving this data weekly and need an automated way to split it up into distinct workbooks by value in column A Thank you in advance for your help. Regards, R- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting worksheet into multiple workbooks
Ron,
Thanks!!! This worked as far as worksheets are concerned, but as a big time novice to this world I'm not sure how to modify to create individual workbooks. Any help with the mods to your worksheet code would be much appreciated as your first example worked great. Thank you again. Rob. "Ron de Bruin" wrote: Hi Rob Here is a example that copy to new sheets You can adapt it for workbooks. If you need help post back http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... have a worksheet that contains multiple records that need to be grouped and exported to a new workbook. Values to group by are in column a, so for example all of the records in column a with a value of 2011 need to go to a workbook named "2011.xls", all of the reocrds in column a with a value 3535 need to go to a new workbook named "3535.xls" etc. etc. I will be receiving this data weekly and need an automated way to split it up into distinct workbooks by value in column A Thank you in advance for your help. Regards, R- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting worksheet into multiple workbooks
Hi Rob
I add a example to my website today, and I will post in this thread when it is ready. -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... Ron, Thanks!!! This worked as far as worksheets are concerned, but as a big time novice to this world I'm not sure how to modify to create individual workbooks. Any help with the mods to your worksheet code would be much appreciated as your first example worked great. Thank you again. Rob. "Ron de Bruin" wrote: Hi Rob Here is a example that copy to new sheets You can adapt it for workbooks. If you need help post back http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... have a worksheet that contains multiple records that need to be grouped and exported to a new workbook. Values to group by are in column a, so for example all of the records in column a with a value of 2011 need to go to a workbook named "2011.xls", all of the reocrds in column a with a value 3535 need to go to a new workbook named "3535.xls" etc. etc. I will be receiving this data weekly and need an automated way to split it up into distinct workbooks by value in column A Thank you in advance for your help. Regards, R- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting worksheet into multiple workbooks
Hi Rob
Here it is http://www.rondebruin.nl/copy5.htm#workbook Please give feedback if you have problems -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Rob I add a example to my website today, and I will post in this thread when it is ready. -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... Ron, Thanks!!! This worked as far as worksheets are concerned, but as a big time novice to this world I'm not sure how to modify to create individual workbooks. Any help with the mods to your worksheet code would be much appreciated as your first example worked great. Thank you again. Rob. "Ron de Bruin" wrote: Hi Rob Here is a example that copy to new sheets You can adapt it for workbooks. If you need help post back http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... have a worksheet that contains multiple records that need to be grouped and exported to a new workbook. Values to group by are in column a, so for example all of the records in column a with a value of 2011 need to go to a workbook named "2011.xls", all of the reocrds in column a with a value 3535 need to go to a new workbook named "3535.xls" etc. etc. I will be receiving this data weekly and need an automated way to split it up into distinct workbooks by value in column A Thank you in advance for your help. Regards, R- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting worksheet into multiple workbooks
Ron, it works like a charm! Thanks so much for your help. Regards. R-
"Ron de Bruin" wrote: Hi Rob Here it is http://www.rondebruin.nl/copy5.htm#workbook Please give feedback if you have problems -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Rob I add a example to my website today, and I will post in this thread when it is ready. -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... Ron, Thanks!!! This worked as far as worksheets are concerned, but as a big time novice to this world I'm not sure how to modify to create individual workbooks. Any help with the mods to your worksheet code would be much appreciated as your first example worked great. Thank you again. Rob. "Ron de Bruin" wrote: Hi Rob Here is a example that copy to new sheets You can adapt it for workbooks. If you need help post back http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... have a worksheet that contains multiple records that need to be grouped and exported to a new workbook. Values to group by are in column a, so for example all of the records in column a with a value of 2011 need to go to a workbook named "2011.xls", all of the reocrds in column a with a value 3535 need to go to a new workbook named "3535.xls" etc. etc. I will be receiving this data weekly and need an automated way to split it up into distinct workbooks by value in column A Thank you in advance for your help. Regards, R- |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
splitting worksheet into multiple workbooks
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... Ron, it works like a charm! Thanks so much for your help. Regards. R- "Ron de Bruin" wrote: Hi Rob Here it is http://www.rondebruin.nl/copy5.htm#workbook Please give feedback if you have problems -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Rob I add a example to my website today, and I will post in this thread when it is ready. -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... Ron, Thanks!!! This worked as far as worksheets are concerned, but as a big time novice to this world I'm not sure how to modify to create individual workbooks. Any help with the mods to your worksheet code would be much appreciated as your first example worked great. Thank you again. Rob. "Ron de Bruin" wrote: Hi Rob Here is a example that copy to new sheets You can adapt it for workbooks. If you need help post back http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Rob" wrote in message ... have a worksheet that contains multiple records that need to be grouped and exported to a new workbook. Values to group by are in column a, so for example all of the records in column a with a value of 2011 need to go to a workbook named "2011.xls", all of the reocrds in column a with a value 3535 need to go to a new workbook named "3535.xls" etc. etc. I will be receiving this data weekly and need an automated way to split it up into distinct workbooks by value in column A Thank you in advance for your help. Regards, R- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple workbooks to one worksheet | Excel Discussion (Misc queries) | |||
splitting a worksheet into multiple worksheets | Excel Discussion (Misc queries) | |||
Splitting a Worksheet into Multiple Sheets | Excel Worksheet Functions | |||
Consolidate multiple workbooks into a single worksheet | Excel Worksheet Functions | |||
Summary Worksheet from Multiple Workbooks | Excel Worksheet Functions |