Linking cells within Excel [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
How do I change one cell in a worksheet one and have it update the other worksheets at the same time within the same Excel file.

Keith

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
214
Suppose you have Cell A2 in Sheet1 now go in Sheet2 , Cell A2 just put =Sheet1!A2
When ever you will change in value in A2 cell of sheet1 your A2 of sheet2 will change automatically ...
12
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month