Hi,
I am currently using these 2 links -
Code:
--------------------
=HYPERLINK("[2005-06.xls]'Timetable'!A"&MATCH(Timetable!K2,Timetable!A:A,0) ,"TIMETABLE")
--------------------
Code:
--------------------
=HYPERLINK("[2005-06.xls]'Timetable'!A"&MATCH(Timetable!K2,Timetable!A:A,0) ,"▼ Goto Today")
--------------------
The only problem is that if the file gets renamed then they stop
working!
Is there any way that I can get the same functionality, but using a
method that doesn't involve file names?
Many thanks.
--
mevetts
------------------------------------------------------------------------
mevetts's Profile:
http://www.excelforum.com/member.php...o&userid=29130
View this thread:
http://www.excelforum.com/showthread...hreadid=532011