| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 104833 | 2009-11-09 22:36:00 | Excel Sheet Linking | Colpol (444) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 828674 | 2009-11-09 22:36:00 | Probably simple but I am not sure how to do it I Have a speadsheet with 5 duty rosters, each on its own Tab. The sixth tab is a master that includes all 5 rosters.(They are not merged just displayed one under the other. How do I link them so that any change to any of the 5 rosters automatically changes the master. Hope this makes sense Colin |
Colpol (444) | ||
| 828675 | 2009-11-09 22:42:00 | I would just simply use the +sheet1:a1+sheet2:a1+sheet3:a1...etc and copy for the entire sheet 6 where data is expected... | SolMiester (139) | ||
| 828676 | 2009-11-09 22:54:00 | I would just simply use the +sheet1:a1+sheet2:a1+sheet3:a1...etc and copy for the entire sheet 6 where data is expected... Thanks Sol. Can you please be a bit more specific as not sure how to do as you suggest. |
Colpol (444) | ||
| 828677 | 2009-11-09 23:12:00 | on the 6th sheet type '=' without the quotes, then click on the cell in the other sheet you want it to show, press 'ENTER' Should get something like =Sheet1!$a$1. Any update to the other sheet will be reflected in sheet 6. |
ManUFan (7602) | ||
| 828678 | 2009-11-09 23:32:00 | on the 6th sheet type '=' without the quotes, then click on the cell in the other sheet you want it to show, press 'ENTER' Should get something like =Sheet1!$a$1. Any update to the other sheet will be reflected in sheet 6. OK I entered = in blank Sheet 6 then went to sheet1. Sheet1 was shown after the= so I pressed enter. When I looked at sheet 6 all it had was the sheet name?? Also got a "Invalid Reference" Message |
Colpol (444) | ||
| 828679 | 2009-11-09 23:54:00 | In sheet 6 @ cell ref A1 type +Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1+Sheet5!A1 | SolMiester (139) | ||
| 828680 | 2009-11-09 23:58:00 | OK I entered = in blank Sheet 6 then went to sheet1. Sheet1 was shown after the= so I pressed enter. When I looked at sheet 6 all it had was the sheet name?? Also got a "Invalid Reference" Message :confused:Did you click the cell it was to be equal too? |
B.M. (505) | ||
| 828681 | 2009-11-10 00:00:00 | In sheet 6 @ cell ref A1 type +Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1+Sheet5!A1 Tried Sol that but all I get on Sheet6 is the names of all the other sheets displayed in ref A1 and a message about a formula error |
Colpol (444) | ||
| 828682 | 2009-11-10 00:05:00 | Tried Sol that but all I get on Sheet6 is the names of all the other sheets displayed in ref A1 and a message about a formula error Eh??....the formula is an example, put a value in cel A1 of etc sheet.....the error may requre a =+ as the 1st 2 characters, the the value in cell A1 should be the dynamic total of the collective sum from all cells in the sheets at A1... |
SolMiester (139) | ||
| 828683 | 2009-11-10 00:10:00 | Eh??....the formula is an example, put a value in cel A1 of etc sheet.....the error may requre a =+ as the 1st 2 characters, the the value in cell A1 should be the dynamic total of the collective sum from all cells in the sheets at A1... Tried putting a + after =. Same result. Sheet names and Formula error |
Colpol (444) | ||
| 1 2 | |||||