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

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

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

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

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

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

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