Paste Special Formula Only

[Guest]

H

Is there a way copying a mixture of values and formulae but when chosing the destination location only the cells with formula are transferred

Thanks

 

[Bernie Deitrick]

Ailish,

After you do your paste, do a Go To... Special.... / Constants Hit
OK, then hit delete.

HTH,
Bernie
MS Excel MVP

Hi

Is there a way copying a mixture of values and formulae but when

chosing the destination location only the cells with formula are
transferred.

 

[Guest]

Thanks a million works a treat!!!