Splitting table by Cost Center

[vsoler]

Hi,

I have a table of data, say in A1:F500, which contains the costs
incurred by all Costs Centers.

The cost center code is in the first column of my table. By using
automatic filter I can see & print each cost center individually.

However, I would like to split my table in as many tables as Cost
Centers I have, without possibly using macros, leaving the new split
tables each in a different sheet, which I can easily then distribute
among collaborators.

Is there a way to do what I am looking for?

Regards & thank you

 

[Ron de Bruin]

Hi vsoler

See
http://www.rondebruin.nl/copy5.htm

 

[greg]

Using XL 2007

Make a pivot table where theReport Filter is the Cost centre name,

then use

PivotTable Tools

Options

"Show Report Filter Pages" command

select the Cost Centre

OK,



(In XL 2003, the command is "Show pages" if I remember correctly.)



This will create a separate sheet for each Cost Centre ... for distibution
among collaborators.



Greg