When using excel sub total function. How do I copy the sub total to another worksheet?
W Webs Apr 27, 2005 #1 When using excel sub total function. How do I copy the sub total to another worksheet?
G Guest Apr 27, 2005 #2 Hi Reduce the grouping to show just the information you want. Hit F5 and select Visible Cells. Ctrl+C to copy. Move to where you want the totals and click Edit / Paste Special / Values.
Hi Reduce the grouping to show just the information you want. Hit F5 and select Visible Cells. Ctrl+C to copy. Move to where you want the totals and click Edit / Paste Special / Values.
