I have a spreadsheet that has tabs for every week of the year. The tab names go; 2022-01-02, 2022-01-09, 2022-01-16, etc.
I have a control sheet (Named "Changes")that has a cell to reference which week a macro taht will use this cell reference to pick the tab to go to
Cell G1 on the "Changes" tab will control which tab the macro should go to
I've tried this but it does not work and I'm at a loss so hoping someone could help
Dim ShtName As String
ShtName = Range(Text(G1, "yyyy-mm-dd"))
Sheets(ShtName).Select
Thanks,
Greg
I have a control sheet (Named "Changes")that has a cell to reference which week a macro taht will use this cell reference to pick the tab to go to
Cell G1 on the "Changes" tab will control which tab the macro should go to
I've tried this but it does not work and I'm at a loss so hoping someone could help
Dim ShtName As String
ShtName = Range(Text(G1, "yyyy-mm-dd"))
Sheets(ShtName).Select
Thanks,
Greg