Highlight the column then select "go to special" then click "visible cells only" this will select the subtotals that are visible. Then you can copy and paste. I hope this is what you were asking. Just took a wild shot since you gave so little information.