Dropkickmurphys

hey, i am currently trying to do some of my IT coursework.

i need to "connect" or "link" two workbooks together, but i cant figure out how, if i try to type the code in one of the books to link to the other it does nothing.

i.e.
it says the "[Final" bit is an invalid name :S

what am i doing wrong? can anyone help?

__________________
Intel Core2 Quad Q6600 2.4Ghz (OC @ 2.5GHz)
Gigabyte P35C-DS3R motherboard
2GB 6400 DDR240 RAM (OC @ 427.5mhz)
512Mb Geforce 8600GT (OC core: 651Mhz, memory: 475Mhz)
500GB Seagate 7,500RPM HDD
Lite-on 20x DVD+RW
OCZ GameXStream 600W PSU
CoolerMaster Black Centurian 534 Case
Samsung 19" 1440x900 SyncMaster 940BW monitor / Samsung 19" 1440x900 TV
Dual Booting: Windows XP Proffessional SP2 / Windows Vista Business SP1

ApexHack

That's the file name, so does it match the name of the workbook you're trying to link to?

I'm not all that familiar with the INDEX function, but realized after playing with it a bit it's just like the references you get when clicking around adding cells to formulas or whatever from wherever including separate workbooks.

Cheers

Dropkickmurphys

yeah, thats the file name, worksheet and it will have the cell reference that i want to link to. but it wont work :S

i have one that was given to me, theres 2 workbooks, they both link together when they work, so i dont know whhy mine wont, unless i need to set something up :S

EDIT: Dont worry, i got it, im not sure how but i got it !! WOO

__________________
Intel Core2 Quad Q6600 2.4Ghz (OC @ 2.5GHz)
Gigabyte P35C-DS3R motherboard
2GB 6400 DDR240 RAM (OC @ 427.5mhz)
512Mb Geforce 8600GT (OC core: 651Mhz, memory: 475Mhz)
500GB Seagate 7,500RPM HDD
Lite-on 20x DVD+RW
OCZ GameXStream 600W PSU
CoolerMaster Black Centurian 534 Case
Samsung 19" 1440x900 SyncMaster 940BW monitor / Samsung 19" 1440x900 TV
Dual Booting: Windows XP Proffessional SP2 / Windows Vista Business SP1