Summing based on 2 criteria matching

[highlystrung]

Hi, I've created a routine that loops down through a spreadsheet and, if the date (column 1) and the Cheque No (column 4) are equal, sums the values of the individual transactions in a new column (called "Transaction totals"). The routine works but I'm sure it's a little longwinded.... Does anyone know a slicker way to approach this? I've added a sample file from the larger application with the relevant sheet and code in it,

thanks for any help or guidance,

regards, neil

Please Login or Register  to view this content.

[AB33]

Try the attached.

[highlystrung]

Hi AB33, thanks for the reply. It doesn't quite do it as needed. When my code runs it leaves all the data rows intact but sums identical rows (based on date and Cheque No.) & puts that total in line with the first row (of the identical lines) - your code reduces all identical rows to 1 row and sums them. Can you rework?

BTW you answered a previous question of mine a while ago using arrays and scripting dictionary which was very successful and useful. I've since taught myself how to use arrays but not good enough to write this code as yet. Hence if you can show me how to do this then, as I have written code to carry out the function, it will be very helpful to learn more by seeing your code versus mine,

best regards, Neil