Paste contents, but keep formula of destination

  • Thread starter Thread starter cynteeuh
  • Start date Start date
C

cynteeuh

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!
 
Each cell can contain a value or a formula (that evaluates to something).

You can't have a cell contain a formula and keep the existing value--unless the
formula evaluates to what was in that cell already.
 
Back
Top