Paste Special?

A

aehan

I want to copy data from a workbook to overwrite data on another workbook but
not to overwrite the formulas. The original worksheet will have either empty
cells or the value of 0 in the cells that contain the formula in the workbook
it is being pasted to. I can't find an option in Paste Special. Can anyone
help with this? Many thanks.
 
A

aehan

Yes, I had gathered that I couldn't use Paste Special, and I wondered if
there was another way of doing it.
 
Top