Hi

I have a list of cost centres sorted in order. I am trying,
unsuccessfully to locate some code which will delete the rows where the
sum of the Cost centres equals 0. This is in a bid to reduce the size
of the file, once reduced I will pivot table the results. Here is an
example of the file;


CCs Value

1211 100
1211 (100)
1222 20
1222 30
1222 10


After the code has run I would like the file to look like this

CC Value

1222 20
1222 30
1222 10

Thanks in advance.

Chad