View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tobias[_2_] Tobias[_2_] is offline
external usenet poster
 
Posts: 11
Default SV: Dynamic hyperlink reference

Yep, did that but it didn't help me...what I want to do, is to activate different cells depending on what week it is right now. This week I want the link to go to c3, next week the same link should go to d3. (The problem is hyperlinks on a sheet where I ask persons what they want to do; if they e.g wants to add forecast data or add the last production data) When they press add data for e.g. project 1, they should be hyperlinked to c3 in another sheet, and next week they should be hyperlinked to d3. I thought of using WeekNum and then according to the WeekNum change the link-reference. And I cannot find that in the helpfile.

Regards
Tobias