Linking the cells just won't work

[FarmerJon]

I'm working with one workbook - two or more worksheets - one cell on each
worksheet. I would like to edit the cell on any one of the worksheets and the
change effect all of the worksheets no matter which worksheet is edited. Plus
be able to repetitivily edit the cell from the same and/or different
worksheet.

I have been playing with:

sheet1>
a1=sheet2$a$1

sheet2>
a1=sheet1$a$1

but I can only edit one or the other once using Excel 2003.

 

[Don Guillett]

a1=sheet2$a$1

a1=sheet2!$a$1

 

[Gord Dibben]

You want to link A1 on each of two sheets to A1 on the other sheet?

How will you enter something in either cell if it has a formula linking it to
the other sheet's A1?


Gord Dibben MS Excel MVP

 

[FarmerJon]

I'm afraid that I need to use Access . What I want to do is for different
users to use different sheets to input data. If one user makes a correction
it is to be seen by all. The master sheet has data that is effected by data
entered by all users and is to be editable also. I appreciate your help.

 

[Don Guillett]

IF?? You want to enter data on sheet1 and have the data automatically
transferred to the master sheet use a worksheet_change event. Then,if you
change it on the master sheet it will stay the same UNLESS you later make a
change on sheet1(or more). I may be way off base because I'm not sure I
understand your need.