Previous Topic Next Topic

Help with excel

Solved/Closed
markzasz Posts 1 Registration date Monday February 21, 2011 Status Member Last seen February 21, 2011 - Feb 21, 2011 at 09:42 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Feb 21, 2011 at 11:50 PM
Hello,

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 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.

I am not able to do that without saving both sheets and reopening them.

Can someone help me.

Thank you,
Mark




Related:

1 response

Answer 1 / 1
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Feb 21, 2011 at 11:50 PM
put formula in g3 of sheet2 as

=Sheet1!C4

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses