software

How do you copy and paste subtotals only? I use the Subtotal feature in
Excel to determine the maximum values for different entities in Excel.
I reduce the list to show the subtotals only and I want to copy and
paste these values in a separate spreadsheet. However, when I copy and
paste the maximum values, Excel pastes all of the data.

Thanks,

Jim--
Jim15
------------------------------------------------------------------------
Jim15's Profile: www.excelforum.com/member.php...oamp;userid=26300
View this thread: www.excelforum.com/showthread...hreadid=494216Use the outlining symbols to the left to show only the subtotals that you want.

Select the range to copy
edit|goto|special|Visible cells only
edit|copy

And paste to that new sheet.

Jim15 wrote:
gt;
gt; How do you copy and paste subtotals only? I use the Subtotal feature in
gt; Excel to determine the maximum values for different entities in Excel.
gt; I reduce the list to show the subtotals only and I want to copy and
gt; paste these values in a separate spreadsheet. However, when I copy and
gt; paste the maximum values, Excel pastes all of the data.
gt;
gt; Thanks,
gt;
gt; Jim
gt;
gt; --
gt; Jim15
gt; ------------------------------------------------------------------------
gt; Jim15's Profile: www.excelforum.com/member.php...oamp;userid=26300
gt; View this thread: www.excelforum.com/showthread...hreadid=494216

--

Dave Peterson