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?