Filter One Sheet into Many

  • Thread starter Thread starter PR
  • Start date Start date
P

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
 
Please decide WHERE you want answers and post ONLY in that group. Why not
just filter or use a pivot table.
 
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,
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
 
Back
Top