Creating a Total values in a table based on cheque numbers

[highlystrung]

Hi, I'm trying to create a final column ("Transaction Totals" in Column L) where the data is summed for the same cheque numbers (Column D). I'm trying to create a loop but getting into a bit of a mesh with it. I've put in the results as they should appear. Can anyone help or advise a better approach on how to do this? I've put in the code that doesn't work and attached a sample file, thanks, Neil

Please Login or Register  to view this content.

[ARGK]

Hi Neil
Can you post a sample layout so we can then see how we can help you.
Tony

[highlystrung]

Hi Tony, I've added a file, regards, NeilAdd column test 18th July 2013.xlsm