Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
yahoo
 
Posts: n/a
Default 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   Report Post  
Max
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel, how do you copy and paste just the subtotals into anoth. mmiazga Excel Discussion (Misc queries) 4 February 13th 05 02:17 AM
Pivot Table subtotals Linda Excel Worksheet Functions 1 February 9th 05 01:46 AM
Sorting a document with subtotals LGoth Excel Discussion (Misc queries) 2 January 28th 05 12:55 AM
why are nested subtotals coming out below outer subtotals? Hendy Excel Worksheet Functions 2 January 18th 05 09:09 PM
Copy/paste Subtotals RichNYC Excel Worksheet Functions 3 November 3rd 04 08:58 AM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"