View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JZ JZ is offline
external usenet poster
 
Posts: 7
Default Copy and Pasting

I have a large sheet in my workbook where the data is updated from another
file everyday using copy and paste special: values. However, there are a
couple of rows in my worksheet that contain formulas that become overriden
everyday when the other file is copied and pasted into my worksheet. Is
there a way to freeze the formula so that everything is pasted over, except
the few formulas that I have in place in the sheet?