Need help with subtotals

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?
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help in making my invoices auto count 1
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Excel Excel: Match, Index and subtract across 2 columns and 2 tabs 2
help with subtotals 2
Help with macro 2
Duplicate entires in multiple tabs 1
Can anybody stop this happening please 4
Auto Change Formulas - Please Help. 2

Top