Summing inv in list

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

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?
 
Excell has an option that will do that without VBA.
Go to: Data --> Subtotal
where you choose what you need....

Good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox filtering 2
Automatic new worksheet creation at each change of value in a first worksheet 2
Sum of data ranges in two different sheets giving two conditions 2
all different records of a column containing more than 1 times each record 1
Logging onto a website 2
Adding values for all rows in a range 6
Match Many to One 1
Excel Excel: Match, Index and subtract across 2 columns and 2 tabs 2

Back
Top