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

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.

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

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

"jpduck" wrote:

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.

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

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 EditPaste SpecialPaste LinkOKEsc.

Change values on Sheet1 and Sheet2 will also change.


Gord Dibben MS Excel MVP

On Mon, 13 Oct 2008 04:48:01 -0700, jpduck
wrote:

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.

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

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

Very much appreciated.