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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

Hi Ron,
Your solution worked perfectly. Thanks for your prompt reply to my
question.


On Dec 6, 3:20 pm, "Ron de Bruin" <rondebr...@kabelfoon.nl> 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" <slowj...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
>
>
> > 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 -