Paste contents, but keep formula of destination

[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!

 

[Don Guillett]

Can you offer a better explanation.

 

[Dave Peterson]

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.