How do you copy & paste the subtotal amount only?

  • Thread starter Thread starter jmaxwell
  • Start date Start date
J

jmaxwell

I am trying to copy a column of subtotal and paste without
the data that makes up the subtotal. I have tried the
special paste values only but excel continues to copy all
the underlying data.

Help would be greatly appreciated.

Thank you
 
Hi,

Try Edit>Goto>Special>Visible cells, then copy & paste normally.

HTH
Anders Silven
 
Back
Top