I have two different worksheets, some of the values on worksheet 1 is the
same as that on worksheet 2. Is there a way that I can use a formula so that
when I change values in worksheet 1 it is automatically changed on the other
sheet?
I have to mention that I am very new to using excel and formulas.
Any help would be much appreciated.