Filter One Sheet into Many

[PR]

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

 

[Don Guillett]

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

 

[Shane Devenshire]

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

 

[Ron de Bruin]

Hi PR

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

 

[PR]

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