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