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

"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