Need help with subtotals

  • Thread starter Thread starter yahoo
  • Start date Start date
Y

yahoo

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?
 
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
 
Back
Top