Hi PJ

Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"pj" wrote in message ...
Hi,
I have a worksheet with much grouped data on it. I would
like to break up this data onto different sheets within
the same workbook.

Is there a way to:

1. add new sheets to a workbook from a macro?
2. rename these sheets (from the macro) with info from
cells in the original sheet?

TIA
pj