View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DFarrar DFarrar is offline
external usenet poster
 
Posts: 2
Default FORMULA TO ADD ROW

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