Copy only sub-totals lines

  • Thread starter Thread starter Brenda Hutton
  • Start date Start date
B

Brenda Hutton

We sub-total a worksheet. Then we want to copy just everything showing on
the sheet when you select option #2 from the 1,2,3 series in the select all
box. How do we do that? We have tried a Paste Special | Values; however,
ALL the data still comes over. What is the trick? TIA!
 
Select the visible table in 2 mode, press F5>special and select visible
cells only,
copy and paste
 
Thank you! It worked like a charm.

Peo Sjoblom said:
Select the visible table in 2 mode, press F5>special and select visible
cells only,
copy and paste

--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top