software

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!!!

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.ukquot;cinvicquot; gt; wrote in message
...
gt; Is it possible?
gt; Say it is so.
gt; I have a worksheet that I need to break up into different excel workbooks.
gt; I did find a macro to break up worksheets into new workbooks but my data
gt; is
gt; all on one worksheet. Is there a way to do this? Say it is so!!!
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:
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.
www.rondebruin.nl/easyfilter.htmYou 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:
www.mvps.org/dmcritchie/excel/getstarted.htm

cinvic wrote:
gt;
gt; Is it possible?
gt; Say it is so.
gt; I have a worksheet that I need to break up into different excel workbooks.
gt; I did find a macro to break up worksheets into new workbooks but my data is
gt; all on one worksheet. Is there a way to do this? Say it is so!!!

--

Dave Peterson

Hi

On this page there is a example for workbooks also
www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;Dave Petersonquot; gt; wrote in message ...
gt; Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
gt; may be sufficient right out of the box.
gt;
gt; Debra's site:
gt; www.contextures.com/excelfiles.html
gt;
gt; Create New Sheets from Filtered List -- uses an Advanced Filter to create
gt; separate sheet of orders for each sales rep visible in a filtered list; macro
gt; automates the filter. AdvFilterRepFiltered.xls 35 kb
gt;
gt; or
gt;
gt; Update Sheets from Master -- uses an Advanced Filter to send data from
gt; Master sheet to individual worksheets -- replaces old data with current.
gt; AdvFilterCity.xls 55 kb
gt;
gt; And Ron de Bruin's easyfilter.
gt; www.rondebruin.nl/easyfilter.htm
gt;
gt;
gt; You may be able to modify them to use separate workbooks--I think as they're
gt; written, they create separate sheets in the same workbook.
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt; cinvic wrote:
gt;gt;
gt;gt; Is it possible?
gt;gt; Say it is so.
gt;gt; I have a worksheet that I need to break up into different excel workbooks.
gt;gt; I did find a macro to break up worksheets into new workbooks but my data is
gt;gt; all on one worksheet. Is there a way to do this? Say it is so!!!
gt;
gt; --
gt;
gt; Dave Peterson
I don't know how you keep track of all your sample code lt;bggt;.

Ron de Bruin wrote:
gt;
gt; Hi
gt;
gt; On this page there is a example for workbooks also
gt; www.rondebruin.nl/copy5.htm
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt; quot;Dave Petersonquot; gt; wrote in message ...
gt; gt; Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
gt; gt; may be sufficient right out of the box.
gt; gt;
gt; gt; Debra's site:
gt; gt; www.contextures.com/excelfiles.html
gt; gt;
gt; gt; Create New Sheets from Filtered List -- uses an Advanced Filter to create
gt; gt; separate sheet of orders for each sales rep visible in a filtered list; macro
gt; gt; automates the filter. AdvFilterRepFiltered.xls 35 kb
gt; gt;
gt; gt; or
gt; gt;
gt; gt; Update Sheets from Master -- uses an Advanced Filter to send data from
gt; gt; Master sheet to individual worksheets -- replaces old data with current.
gt; gt; AdvFilterCity.xls 55 kb
gt; gt;
gt; gt; And Ron de Bruin's easyfilter.
gt; gt; www.rondebruin.nl/easyfilter.htm
gt; gt;
gt; gt;
gt; gt; You may be able to modify them to use separate workbooks--I think as they're
gt; gt; written, they create separate sheets in the same workbook.
gt; gt;
gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt;
gt; gt; cinvic wrote:
gt; gt;gt;
gt; gt;gt; Is it possible?
gt; gt;gt; Say it is so.
gt; gt;gt; I have a worksheet that I need to break up into different excel workbooks.
gt; gt;gt; I did find a macro to break up worksheets into new workbooks but my data is
gt; gt;gt; all on one worksheet. Is there a way to do this? Say it is so!!!
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson

You guys are great!!! Thanks for the advice - I'll be back if I need more
ideas.

quot;Dave Petersonquot; wrote:

gt; I don't know how you keep track of all your sample code lt;bggt;.
gt;
gt; Ron de Bruin wrote:
gt; gt;
gt; gt; Hi
gt; gt;
gt; gt; On this page there is a example for workbooks also
gt; gt; www.rondebruin.nl/copy5.htm
gt; gt;
gt; gt; --
gt; gt; Regards Ron de Bruin
gt; gt; www.rondebruin.nl
gt; gt;
gt; gt; quot;Dave Petersonquot; gt; wrote in message ...
gt; gt; gt; Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
gt; gt; gt; may be sufficient right out of the box.
gt; gt; gt;
gt; gt; gt; Debra's site:
gt; gt; gt; www.contextures.com/excelfiles.html
gt; gt; gt;
gt; gt; gt; Create New Sheets from Filtered List -- uses an Advanced Filter to create
gt; gt; gt; separate sheet of orders for each sales rep visible in a filtered list; macro
gt; gt; gt; automates the filter. AdvFilterRepFiltered.xls 35 kb
gt; gt; gt;
gt; gt; gt; or
gt; gt; gt;
gt; gt; gt; Update Sheets from Master -- uses an Advanced Filter to send data from
gt; gt; gt; Master sheet to individual worksheets -- replaces old data with current.
gt; gt; gt; AdvFilterCity.xls 55 kb
gt; gt; gt;
gt; gt; gt; And Ron de Bruin's easyfilter.
gt; gt; gt; www.rondebruin.nl/easyfilter.htm
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; You may be able to modify them to use separate workbooks--I think as they're
gt; gt; gt; written, they create separate sheets in the same workbook.
gt; gt; gt;
gt; gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt; gt;
gt; gt; gt; cinvic wrote:
gt; gt; gt;gt;
gt; gt; gt;gt; Is it possible?
gt; gt; gt;gt; Say it is so.
gt; gt; gt;gt; I have a worksheet that I need to break up into different excel workbooks.
gt; gt; gt;gt; I did find a macro to break up worksheets into new workbooks but my data is
gt; gt; gt;gt; all on one worksheet. Is there a way to do this? Say it is so!!!
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt;
gt; --
gt;
gt; Dave Peterson
gt;

YOU PEOPLE ARE AWSOME!!! It worked - I created new worksheets from one master
worksheet. THANKS for your help.

quot;cinvicquot; wrote:

gt; Is it possible?
gt; Say it is so.
gt; I have a worksheet that I need to break up into different excel workbooks.
gt; I did find a macro to break up worksheets into new workbooks but my data is
gt; all on one worksheet. Is there a way to do this? Say it is so!!!