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.

"Dave Peterson" wrote:

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.



rajkohli wrote:

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

"Peo Sjoblom" wrote:

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



"rajkohli" wrote in message
...
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/comm...lic.excel.misc




--

Dave Peterson