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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reconcilling list
You can also use Data, Subtotals but you first have to
sort the list. Use Sum of Bk Ref. If you want to restore the original order later you might want to have an Id No for each item. Regards Peter -----Original 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reconcilling list
Sorry
Use Sum on Amount at each change in BkRef Regards Peter -----Original 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 |
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 |