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


--

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


"emme" wrote in message ...
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?