Hi,
maybe a Pivot Table might be a solution to your problem


BabyMc;324866 Wrote:
Hi

I have a database that is to contain columns such as:

A B C
Cost Centre Code Amount
100000 100 50.00
100000 110 55.00
200000 150 100.00
300000 120 101.45
300000 140 210.00

etc (I would expect up to, say, 20-30 cost centres and a few hundred
codes)

The above table would then change each month (i.e. new codes and
amounts may
be added).
I would then like to create further worksheets (one for each cost
centre)
that shows only the code and related amount for that cost centre.
The only ways I have done this is previously is to either manually add
the
codes for the cost centre to that cost centre's worksheet or to add all
codes
to every worksheet and then filter the rows with no data. The first
solution
is laborious as a search for missing codes must be carried out each
time; the
second works reasonably well but I end up with a large amount of
lookups
which impacts on calculation perofrmance.

Is there a way of doing this dynamically?

Thanks


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90779