new sheet ops in macro

[pj]

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

 

[Ron de Bruin]

Hi PJ

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

 

[Guest]

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" <[email protected]> wrote in

message news:[email protected]...