Copying Sub-Total Values

[Guest]

Using Microsoft Excel 2003 SP2. Suggestion is about copying SubTotal values
to another sheet.

As we know that when we make sub-totals in Excel, it also create group and
outline view on the left side pane, which we can use to see like:

Complete Detail
Sub-Totals Only
Grand Totals Only

The problem is, when we copy only sub-totals values from view no. 2 and
paste them to some another sheet, Excel copy all the data not only sub-totals.

I had notified Microsoft's Write Us about this bug/suggestion with a
complete detail but still no reply.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7-b1996b734801&dg=microsoft.public.excel.misc

 

[Peo Sjoblom]

It's not a bug and you would be better off (you would save wasted time) if
you did some research before writing MS

Select the range you want to copy, press F5, select special and visible
cells only, copy



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

That doesn't work! Error "The selection contain visible cells only". You
should try it once.

 

[Dave Peterson]

Did you hide the details first?
Then use Peo's suggestion?

And if you did hide the details, then followed Peo's suggestion twice(!), you'd
get this warning the second time.

 

[Guest]

Still not working. According to me there is no solution. Let me know, have
you ever try this practically.

I want to copy only the Sub-Total's summary to another sheet. For instance,
I have a sheet with 100s row list, which include 10 sub-totals. I want to
copy only the subtotals from view no. 2 to some another sheet.

I had tried what Peo suggest but didn't work. Please try it once and let me
know, if I am doing it wrong.

 

[Guest]

Extremely sorry! Was not doing it good manner.
Thanks for help. I've learned a new thing.