Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
While linking to other work sheets | New Users to Excel | |||
Linking one work book to another.... | Excel Worksheet Functions | |||
work sheet linking | Excel Discussion (Misc queries) | |||
Linking with equals sign doesn't always work | Excel Worksheet Functions | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) |