| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
One worksheet becomes many files?
Is it possible?
Say it is so. I have a worksheet that I need to break up into different excel workbooks. I did find a macro to break up worksheets into new workbooks but my data is all on one worksheet. Is there a way to do this? Say it is so!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
One worksheet becomes many files?
You would need a macro, but we would need far more detail of what the data
on the source worksheet looks like and what you want moving to new sheets -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk "cinvic" wrote in message ... Is it possible? Say it is so. I have a worksheet that I need to break up into different excel workbooks. I did find a macro to break up worksheets into new workbooks but my data is all on one worksheet. Is there a way to do this? Say it is so!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
One worksheet becomes many files?
Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
may be sufficient right out of the box. Debra's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm You may be able to modify them to use separate workbooks--I think as they're written, they create separate sheets in the same workbook. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm cinvic wrote: Is it possible? Say it is so. I have a worksheet that I need to break up into different excel workbooks. I did find a macro to break up worksheets into new workbooks but my data is all on one worksheet. Is there a way to do this? Say it is so!!! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
One worksheet becomes many files?
Hi
On this page there is a example for workbooks also http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin may be sufficient right out of the box. Debra's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm You may be able to modify them to use separate workbooks--I think as they're written, they create separate sheets in the same workbook. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm cinvic wrote: Is it possible? Say it is so. I have a worksheet that I need to break up into different excel workbooks. I did find a macro to break up worksheets into new workbooks but my data is all on one worksheet. Is there a way to do this? Say it is so!!! -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
One worksheet becomes many files?
I don't know how you keep track of all your sample code <bg.
Ron de Bruin wrote: Hi On this page there is a example for workbooks also http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin may be sufficient right out of the box. Debra's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm You may be able to modify them to use separate workbooks--I think as they're written, they create separate sheets in the same workbook. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm cinvic wrote: Is it possible? Say it is so. I have a worksheet that I need to break up into different excel workbooks. I did find a macro to break up worksheets into new workbooks but my data is all on one worksheet. Is there a way to do this? Say it is so!!! -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
One worksheet becomes many files?
You guys are great!!! Thanks for the advice - I'll be back if I need more
ideas. "Dave Peterson" wrote: I don't know how you keep track of all your sample code <bg. Ron de Bruin wrote: Hi On this page there is a example for workbooks also http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin may be sufficient right out of the box. Debra's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm You may be able to modify them to use separate workbooks--I think as they're written, they create separate sheets in the same workbook. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm cinvic wrote: Is it possible? Say it is so. I have a worksheet that I need to break up into different excel workbooks. I did find a macro to break up worksheets into new workbooks but my data is all on one worksheet. Is there a way to do this? Say it is so!!! -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
One worksheet becomes many files?
YOU PEOPLE ARE AWSOME!!! It worked - I created new worksheets from one master
worksheet. THANKS for your help. :) "cinvic" wrote: Is it possible? Say it is so. I have a worksheet that I need to break up into different excel workbooks. I did find a macro to break up worksheets into new workbooks but my data is all on one worksheet. Is there a way to do this? Say it is so!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
| How do I reference data from one worksheet to another using combob | New Users to Excel | |||
| Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Linear Mode
