Hi Guys/Gals,

Im trying to link 2 cells from 2 diffrent worksheets but it doesnt seem
to work. I either get a 0 or #VALUE.

My Spreadsheet has 5 Worksheets (League Table, Week 1, Week 2, Week 3,
Week 4). Im trying to do 2 different things.

1. Fields to contain the same Name so when its changed on one will
change on the other.
2. Add up things from different cells from diff worksheets

The code im using is

1.
Code:
--------------------
='League Table'!B23:C23
--------------------

2.
Code:
--------------------
='Week 1'!I7:I8+'Week 2'!H19:H20+'Week 3'!H19:H20+'Week 4'!H10:H11
--------------------


Please please please help me


--
kusky
------------------------------------------------------------------------
kusky's Profile: http://www.excelforum.com/member.php...o&userid=36816
View this thread: http://www.excelforum.com/showthread...hreadid=565228