Quote:
Originally Posted by Markzas
Hello,
I am trying to copy a value of one cell from one spreadsheet to a cell of another spreadsheet. and below is what i have comeup with so far. Can someone help or show me a better way?
i have two speadsheets.
the first sheet contains a total column
EX: in C4
=SUM(E4+G4+I4+K4+M4)
Value of C4 = (339816)
----------------------------------------------------
on the second sheet i would like the values
i have the following coded:
=SUM('C:\Free Space\[SYC.xls]ECC'!C4)
but when i update (sheet1) C4 the value in Sheet2(G3) is not updated
until, I save both sheets and reopen them.
How can:
i would like the of C4 from sheet one placed on sheet two
G3.
how ever if the value of C4 (sheet1) is altered i would like the
value in G3(sheet2) to reflect the chage immediately.
Can someone help me.
Thank you,
Mark
|
------------------------------------------------------------------------
Dear Markzas, Good Afternoon.
If you want just the G3 cell at a sheet2, to have the SAME value of a C4 cell at a C:\Free Space\[SYC.xls]ECC'! (sheet1) you just need to DO:
G3 (sheet2) = ´C:\Free Space\[SYC.xls]ECC'!C4
The value at Sheet2 is updated immediately every time the value is changed at sheet1.
Tell me if it worked for you.