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 ?

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 ?

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 ?

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 ?