Hyperlink

S

Scurloc

Hi all,

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

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

I have hyperlinked each contact in the main spreadsheet to this wee
spreasheet.

Now my problem is that I would need this hyperlink to chang
automatically to the next week spreadsheet once next Monday starts.

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

Thank you in davance for your help

Se
 
Top