Copy text

[salonowiec]

In Sheet3 I have my formula ( e.g. MOD(H7)), and I want the result to be
copied automatically to Sheet1 - the value only. Which function would do it
for me?

 

[Stan Brown]

In Sheet3 I have my formula ( e.g. MOD(H7)), and I want the result to be
copied automatically to Sheet1 - the value only. Which function would do it
for me?

Think about it this way: Excel doesn't copy results *to* cells, it
pulls results *from* cells.

In Sheet1, in the cell you want the result copied to, put this
formula:

=Sheet3!P47

(assuming P47 is the cell in Sheet3 where you have your formula).