| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA TO ADD ROW
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 In article , DFarrar wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FORMULA TO ADD ROW
Thank you so much. This was perfect!
"Domenic" wrote: 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 In article , DFarrar wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
