I have a workbook has the same tabs every month and each month I need to
parse out the tabs in the same way to separate workbooks. Is there a way to
automate this?

As an example, let's say my workbook has 10 tabs labeled tab1 to tab10.
Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook,
etc.

I don't know VBA at all, can anyone help?

See
http://www.rondebruin.nl/copy6.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"emme" <(E-Mail Removed)> wrote in message news:9BC420C0-0B3E-46F2-9A0C-(E-Mail Removed)...
>I have a workbook has the same tabs every month and each month I need to
> parse out the tabs in the same way to separate workbooks. Is there a way to
> automate this?
>
> As an example, let's say my workbook has 10 tabs labeled tab1 to tab10.
> Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook,
> etc.
>
> I don't know VBA at all, can anyone help?

thank you. is there a way to copy only certain tabs? i need to parse out to
several separate workbooks. how would i modyify your code?

"Ron de Bruin" wrote:

> See
> http://www.rondebruin.nl/copy6.htm
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "emme" <(E-Mail Removed)> wrote in message news:9BC420C0-0B3E-46F2-9A0C-(E-Mail Removed)...
> >I have a workbook has the same tabs every month and each month I need to
> > parse out the tabs in the same way to separate workbooks. Is there a way to
> > automate this?
> >
> > As an example, let's say my workbook has 10 tabs labeled tab1 to tab10.
> > Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook,
> > etc.
> >
> > I don't know VBA at all, can anyone help?
>

What is the criteria ?
Sheets names that start with ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"emme" <(E-Mail Removed)> wrote in message news:332FF2C9-CE56-4781-B7D8-(E-Mail Removed)...
> thank you. is there a way to copy only certain tabs? i need to parse out to
> several separate workbooks. how would i modyify your code?
>
> "Ron de Bruin" wrote:
>
>> See
>> http://www.rondebruin.nl/copy6.htm
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "emme" <(E-Mail Removed)> wrote in message news:9BC420C0-0B3E-46F2-9A0C-(E-Mail Removed)...
>> >I have a workbook has the same tabs every month and each month I need to
>> > parse out the tabs in the same way to separate workbooks. Is there a way to
>> > automate this?
>> >
>> > As an example, let's say my workbook has 10 tabs labeled tab1 to tab10.
>> > Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook,
>> > etc.
>> >
>> > I don't know VBA at all, can anyone help?
>>