View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Copying Cells in List

Hi,

This should work.
Select the range with your subtotals in then

Edit|Goto|Special
Select Visible cells only
Click OK
Copy and paste as you require.

Mike

"infinite1013" wrote:

If i have my cells sorted and subtotaled and close the brackets to show only
the subtotals, is there a way that I can copy only those subtotals without
copying all of the figures that make them up?