Copying Cells in List

[infinite1013]

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?

 

[ScottFisher2004]

Copy the subtoal cells. Go to where you want the values pasted. Then select
Edit from the menu bar, Paste Special from the drop-down, click 'values', and
select okay.

 

[Mike H]

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