new sheet ops in macro
 

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

new sheet ops in macro
 

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

new sheet ops in macro
 

Hi Ron,
Well, that may work. But in the same macro (further up) is
code importing the data from a large number of text files
to an initial worksheet. Each of these text files is a
different grouping of data, comma delimited, with an ID
buried within it that I'll be using for the name. So I
don't know ahead of time what will be the data in the
cells I'll be copying from to name the newly created
worksheets.

I guess I'll have to play around with it. Thanks.
pj

-----Original Message-----
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





.