Thread
:
Reconcilling list
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Reconcilling list
Have a look at datafilterautofilter
--
Don Guillett
SalesAid Software
"Ed" wrote in message
...
I have a list with the following columns
Bk Ref Name Amount
655142 Jones 200
655142 Jones 100
655142 Jones -300
602548 Martin 100
This is a list that i have combined from two systems and i
need to match the credits and debits.
Is there any VBA that i could use to Sum the total of all
the same bk ref and if it doesnt equal zero to either
highlight in a different colour or copy to another
location?
Many thanks
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]