can I change the values in two worksheets at the same time

[jpduck]

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.

 

[Mike H]

Hi,

Put this in any cell on any sheet and if a1 on Sheet 1 is changed then this
wil update the cell on that sheet

=Sheet1!A1

Mike

 

[Gord Dibben]

Easiest method is to link the cells from Sheet1 to Sheet2

Select the cells in Sheet1 and Copy.

Go to Sheet2 and select a cell and Edit>Paste Special>Paste Link>OK>Esc.

Change values on Sheet1 and Sheet2 will also change.


Gord Dibben MS Excel MVP

 

[jpduck]

a quick thanks to both of you for your help with my problem.

Very much appreciated.