I would like to create many sheets out of one... I have a dataset which has
a group column, I want to be able to create a sheet for each group in this
column and only have those records displayed on the new sheet and name the
sheet by the group...

Is there a way of doing this?

Regards - Paul

Please decide WHERE you want answers and post ONLY in that group. Why not
just filter or use a pivot table.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PR" wrote in message
...
I would like to create many sheets out of one... I have a dataset which has
a group column, I want to be able to create a sheet for each group in this
column and only have those records displayed on the new sheet and name the
sheet by the group...

Is there a way of doing this?

Regards - Paul

Hi,

1. To do it all with one command you would need to write VBA code.

2. Manually you would use Filter, Advanced Filter, Copy to a new location....
(filtering to a different sheet is a bit tricky so you should read up on it.)

3. You could make a pivot table out of your data and then
1. Use the Show Pages command
or
2. Use the drill down on the group subtotals

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"PR" wrote:

I would like to create many sheets out of one... I have a dataset which has
a group column, I want to be able to create a sheet for each group in this
column and only have those records displayed on the new sheet and name the
sheet by the group...

Is there a way of doing this?

Regards - Paul

Hi PR

Here is a code example to do this
http://www.rondebruin.nl/copy5.htm

--

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


"PR" wrote in message ...
I would like to create many sheets out of one... I have a dataset which has
a group column, I want to be able to create a sheet for each group in this
column and only have those records displayed on the new sheet and name the
sheet by the group...

Is there a way of doing this?

Regards - Paul

Ron,
Thanks very much it works and is excellent... is there a way to only run a
macro once... i.e if the routine has ran and all the sheets have been
created, I do not want the marco to be able run again? until the next time I
open a new sheet

Regards - Paul