Excell has an option that will do that without VBA.
Go to: Data -- Subtotal
where you choose what you need....

Good luck


-----Original Message-----
I have a list of different invoices with supplier
reference numbers in the next column. What i want to do
is
sum the total for each supplier and either copy this to a
new sheet or delete the multiple invoice lines and just
keep the sum of the invoices, is this possible?
.