Hello!
Let's say in A1 we have number 5
and in B1 the formula =2*A1
And then, in E5 we have number 6
If I CUT the whole cell E5 and paste them in A1, in B1 I get #REF.
Is there a way to make excel accept the new value (6) and return 12 as the result?
I know it's possible to do it if I COPY (not CUT) the cell, or just copy the contents instead of the whole cell, but I need it the other way...
Bookmarks