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!

Can you offer a better explanation.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cynteeuh" wrote in message
news
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.

cynteeuh wrote:

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!

--

Dave Peterson