'Weekly tracking tables for follow-up

I need your help!

I am building in excel a weekly follow-up that for example from the column D to column O there is a table with comments for the week 1 then column P there is nothing and from column Q to column AB there is a table with comments for the week 2...and so on until week 52. I want create a macro that just shows me the current week and then i can use two arrows "Back" & "Next" to navigate on the the other weeks. The table consist in 12 columns and 1 column between the next table I developed a very manual code but it will consume me time to do it until week 52.

Sub Week2BACK() {for the button "Back"} 

Columns("Q:XEE").EntireColumn.Hidden = True


Columns("D:O").EntireColumn.Hidden = False

End Sub

Sub Week2NExt() {for the button "Next"} 

Columns("D:AB").EntireColumn.Hidden = True

Columns("AP:XEE").EntireColumn.Hidden = True

Columns("AD:AO").EntireColumn.Hidden = False

End Sub

There is a way to make it faster? Because i want that is just shown one week at time on the worksheet.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source