Copy/paste Subtotals

[Guest]

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 ?

 

[Frank Kabel]

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

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 ?

 

[Guest]

Works... Thanks Alot !!!!!

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


better ?

 

[Guest]

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