Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Sub-Total Values
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Sub-Total Values
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Sub-Total Values
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Sub-Total Values
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Sub-Total Values
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Sub-Total Values
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Copying Specific Values From Sheet | Excel Discussion (Misc queries) | |||
Copying cell values once and then making them static | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Index to determine total of values | Excel Worksheet Functions |