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

  • Thread starter Thread starter jpduck
  • Start date Start date
J

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