Linking the cells just won't work
 

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.

Linking the cells just won't work
 

a1=sheet2$a$1
a1=sheet2!$a$1


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FarmerJon" wrote in message
...
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.

Linking the cells just won't work
 

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

On Sat, 1 Dec 2007 13:55:01 -0800, FarmerJon
wrote:

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.

Linking the cells just won't work
 

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.

"Gord Dibben" wrote:

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

On Sat, 1 Dec 2007 13:55:01 -0800, FarmerJon
wrote:

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.

Linking the cells just won't work
 

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FarmerJon" wrote in message
...
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.

"Gord Dibben" wrote:

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

On Sat, 1 Dec 2007 13:55:01 -0800, FarmerJon
wrote:

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.