|Subject:||Splitting table by Cost Center|
|Posted by:||vsoler (vicente.sol…@gmail.com)|
|Date:||Thu, 31 Jul 2008|
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
Is there a way to do what I am looking for?
Regards & thank you