paste special in a formula

Hello all,

if A is my original data, B is formula applied to A, how to get formula in C = Paste / Paste special /Values of B

Thanks

You can't paste special using formula. Formula are fundamentally volatile, so if a formula in column C is dependent on the value in column B and the value in column B changes then so will the value in column C.

So your choices are either do manual copy, paste special|values to periodically extract values from column B, or have a macro to do it for you.