View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cynteeuh cynteeuh is offline
external usenet poster
 
Posts: 1
Default 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!