FORMULA TO ADD ROW

  • Thread starter Thread starter DFarrar
  • Start date Start date
D

DFarrar

I have a spreadsheet that I need to automatically insert a row after each
different invoice #,as my spreadsheet lists each item on the invoices. Then
I need to automatically total the amounts of the items for that invoice. Is
this possible?
DATE ITEM INVOICE # AMT
05/01 A 1234 25
05/01 B 1234 30
05/02 A 4321 25
05/02 C 4321 10
05/02 D 4321 15
 
First select your data, then on the menu bar select...

Data > Subtotals

....and make the appropriate selections.
 
Thank you so much. This was perfect!

Domenic said:
First select your data, then on the menu bar select...

Data > Subtotals

....and make the appropriate selections.

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions
Click to expand...
 
Back
Top