On Tue, 15 Nov 2011 10:28:31 +0100, salonowiec wrote:
>
> 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).
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
