Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reconcilling list
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |