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?
|