PDA

View Full Version : Excel Sheet Linking



Colpol
10-11-2009, 11:36 AM
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

SolMiester
10-11-2009, 11:42 AM
I would just simply use the +sheet1:a1+sheet2:a1+sheet3:a1...etc and copy for the entire sheet 6 where data is expected...

Colpol
10-11-2009, 11:54 AM
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.

ManUFan
10-11-2009, 12:12 PM
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.

Colpol
10-11-2009, 12:32 PM
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

SolMiester
10-11-2009, 12:54 PM
In sheet 6 @ cell ref A1 type +Sheet1!A1+Sheet2!A1+Sheet3!A1+Sheet4!A1+Sheet5!A1

B.M.
10-11-2009, 12:58 PM
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?

Colpol
10-11-2009, 01:00 PM
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

SolMiester
10-11-2009, 01:05 PM
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...

Colpol
10-11-2009, 01:10 PM
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
10-11-2009, 01:31 PM
Just a thought.
What I am trying to link is not numbers but names symbols and formating.
Would this be why it is not working as it should.

SolMiester
10-11-2009, 02:23 PM
Just a thought.
What I am trying to link is not numbers but names symbols and formating.
Would this be why it is not working as it should.

YES!!!

You better try asking your question again!

Colpol
10-11-2009, 02:59 PM
Ooops