Copy text

  • Thread starter Thread starter salonowiec
  • Start date Start date
S

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?
 
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?
Click to expand...

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).
 
Back
Top