Filter One Sheet into Many "PR" <paul.raeburn[ at ]vodafone.net> 12/29/2008 8:59:19 PM 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

Re: Filter One Sheet into Many "Don Guillett" <dguillett1[ at ]austin.rr.com> 12/29/2008 9:05:36 PM 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 dguillett1[ at ]austin.rr.com "PR" <paul.raeburn[ at ]vodafone.net> wrote in message news:e2XzRhfaJHA.4480[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] >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 >

RE: Filter One Sheet into Many Shane Devenshire 12/29/2008 9:12:01 PM 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: [Quoted Text] > 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 > > >

Re: Filter One Sheet into Many "Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 12/29/2008 10:41:27 PM 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" <paul.raeburn[ at ]vodafone.net> wrote in message news:e2XzRhfaJHA.4480[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] >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 > >

Re: Filter One Sheet into Many "PR" <paul.raeburn[ at ]vodafone.net> 12/30/2008 8:55:41 PM 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