Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with subtotals
I have a spreadsheet of invoices and the items that are on the invoice
I sort by invoice number and subtotal by invocie which gives me a total of each invoice - invoice number and total on same line what I want to do is copy the list of invoice numbers and their totals to a new spreadsheet - the problem is when I do this the items on the invoice copy over as well. What can I do? |
#2
|
|||
|
|||
Assuming the table is collapsed to suit
Select the range Press F5 Special Visible cells only OK Right-click on the selection Copy Then just go to the new sheet paste -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "yahoo" wrote in message ... I have a spreadsheet of invoices and the items that are on the invoice I sort by invoice number and subtotal by invocie which gives me a total of each invoice - invoice number and total on same line what I want to do is copy the list of invoice numbers and their totals to a new spreadsheet - the problem is when I do this the items on the invoice copy over as well. What can I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
Pivot Table subtotals | Excel Worksheet Functions | |||
Sorting a document with subtotals | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Copy/paste Subtotals | Excel Worksheet Functions |