How do you copy & paste the subtotal amount only?

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
 
A

Anders S

Hi,

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

HTH
Anders Silven
 
Top