Splitting table by Cost Center

Giganews Newsgroups
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
among collaborators.

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

Regards & thank you