Hyperlink

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Hi all,

I have a quite unusual request I think... :)

In one Excel document I have 1 main spread*** with contacts' details
and several spreadsheets (one per week) each representing one week of
the year . Each week spread*** has got a timetable inside going from
Monday/Month/Year to Sunday/Month/Year.

I have hyperlinked each contact in the main spread*** to this week
sprea***.

Now my problem is that I would need this hyperlink to change
automatically to the next week spread*** once next Monday starts.

Is there any way somebody could help me with this? :confused:

Thank you in davance for your help

Seb


--
Scurloc
------------------------------------------------------------------------
Scurloc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29854
View this thread: http://www.excelforum.com/showthread.php?threadid=518716

.

Quantcast