Navigating to Worksheet

[Legacy 436357]

Hello,

I have my first sheet 'Switchboard' that has this formula in Cell E1:

=WEEKNUM(TODAY(),2)

This yields '28' for the 28th week of the year.

My worksheets are labeled Week 1, Week 2, etc.

Since this is the 28th week of the year is there a way to jump to that worksheet (Week 28) ?

Thank you,

 

[MoshiM]

Hello,

I have my first sheet 'Switchboard' that has this formula in Cell E1:

=WEEKNUM(TODAY(),2)

This yields '28' for the 28th week of the year.

My worksheets are labeled Week 1, Week 2, etc.

Since this is the 28th week of the year is there a way to jump to that worksheet (Week 28) ?

Thank you,

Sub GoToSheet() 
 D=thisworkbook.worksheets("Switchboard").range("E1").VALUE
thisworkbook.worksheets("Week " & D).activate
end sub

 

[Fluff]

Using a formula
=HYPERLINK("#'Week "&WEEKNUM(TODAY(),2)&"'!B3","This Week")

 

[Legacy 436357]

Perfect! Thank you MoshiM

 

[Legacy 436357]

The formula likely works too thanks Fluff.

Is there a way to go back to the Switchboard sheet?

 

[Fluff]

You could add a hyperlink on each sheet that points back to the Switchboard

 

[Legacy 436357]

Thanks Fluff I will do that.

 

[Fluff]

You're welcome.