Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RichNYC
 
Posts: n/a
Default Copy/paste Subtotals

Working with a long list of items and sales $$ for each item. Most of the
items have multiple sales per year at different prices.....I want to
determine the total sales of a specific item. So..I sort by
"item"...subtotal....at each change in "item" use function "sum" on the
column which contains the revenue for that specific line item. Im OK until
then. Now I need to sort the subtotaled list...so I can determine the
highest/lowest selling units. However I can't sort the subtotals....also
can't copy/paste the subtotals without all of the background detail going
with it. Any solutions ?? Any other functions that may work better ?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
- apply subtotal
- collaps your data range
- select the range
- hit F5, click 'Special' and choose 'visible cells only'
- now copy and paste

--
Regards
Frank Kabel
Frankfurt, Germany

"RichNYC" schrieb im Newsbeitrag
...
Working with a long list of items and sales $$ for each item. Most of

the
items have multiple sales per year at different prices.....I want to
determine the total sales of a specific item. So..I sort by
"item"...subtotal....at each change in "item" use function "sum" on

the
column which contains the revenue for that specific line item. Im

OK until
then. Now I need to sort the subtotaled list...so I can determine

the
highest/lowest selling units. However I can't sort the

subtotals....also
can't copy/paste the subtotals without all of the background detail

going
with it. Any solutions ?? Any other functions that may work

better ?

  #3   Report Post  
RichNYC
 
Posts: n/a
Default

Works... Thanks Alot !!!!!

"Frank Kabel" wrote:

Hi
- apply subtotal
- collaps your data range
- select the range
- hit F5, click 'Special' and choose 'visible cells only'
- now copy and paste

--
Regards
Frank Kabel
Frankfurt, Germany

"RichNYC" schrieb im Newsbeitrag
...
Working with a long list of items and sales $$ for each item. Most of

the
items have multiple sales per year at different prices.....I want to
determine the total sales of a specific item. So..I sort by
"item"...subtotal....at each change in "item" use function "sum" on

the
column which contains the revenue for that specific line item. Im

OK until
then. Now I need to sort the subtotaled list...so I can determine

the
highest/lowest selling units. However I can't sort the

subtotals....also
can't copy/paste the subtotals without all of the background detail

going
with it. Any solutions ?? Any other functions that may work

better ?


  #4   Report Post  
K.S.Warrier
 
Posts: n/a
Default

Hi,
Use two columns for each item,one for sales value and the other for
subtotals.{sum($1st sell ref$:next cell ref)} which will give you the
subtotal at each stage if reqired.If found useful,pl try.
kswarrier

"RichNYC" wrote:

Working with a long list of items and sales $$ for each item. Most of the
items have multiple sales per year at different prices.....I want to
determine the total sales of a specific item. So..I sort by
"item"...subtotal....at each change in "item" use function "sum" on the
column which contains the revenue for that specific line item. Im OK until
then. Now I need to sort the subtotaled list...so I can determine the
highest/lowest selling units. However I can't sort the subtotals....also
can't copy/paste the subtotals without all of the background detail going
with it. Any solutions ?? Any other functions that may work better ?

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
why are nested subtotals coming out below outer subtotals? Hendy Excel Worksheet Functions 2 January 18th 05 09:09 PM
Pivot table subtotals 100% JaniceHill Excel Discussion (Misc queries) 1 December 17th 04 12:51 AM
Subtotals Ram Excel Worksheet Functions 2 November 3rd 04 01:53 AM
Sorting a list with subtotals Matt B. Excel Worksheet Functions 2 October 29th 04 01:19 PM


All times are GMT +1. The time now is 03:24 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"