Paste contents, but keep formula of destination
Hi,
I've searched for a solution for this, but I cannot find it. Apologies if
this is a duplicate.
I want to copy the values only of a selection to another sheet, but I want
to keep the formulas of the destination sheet (where copied)? When I copy the
data to the new sheet, I lose the formulas of the existing (destination)
sheet. Is there anyway to copy without losing the existing formulas of where
I'm copying?
Thanks in advance for your help!
|