Link to different sheets based on cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-1307915%22%20slang%3D%22en-US%22%3ELink%20to%20different%20sheets%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1307915%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20that%20I%20can%20add%20a%20lot%20of%20dated%20information%20to%2C%20and%20then%2012%20more%20sheets%2C%20one%20for%20each%20month.%20I%20would%20like%20to%20have%20a%20button%20with%20a%20link%20set%20up%20that%20will%20go%20to%20the%20current%20month%20sheet.%20The%20current%20month%20is%20April%2C%20so%20click%20on%20the%20current%20month%20button%20and%20it%20will%20take%20me%20to%20the%20April%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1307915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1307960%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20different%20sheets%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1307960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F618946%22%20target%3D%22_blank%22%3E%40sammage34%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20the%20current%20month%20April%20is%20in%20the%20cell%20%22A1%22%26nbsp%3B%20and%20you%20have%20got%20the%20sheet%20named%20%22April%22%3C%2FP%3E%3CP%3Eyou%20can%20use%20the%20formula%3A%26nbsp%3B%3DHYPERLINK(%22%23%22%26amp%3BA1%26amp%3B%22!A1%22%2CA1)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1308545%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20different%20sheets%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308545%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F621896%22%20target%3D%22_blank%22%3E%40tbula%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20formula%20works%20great!%20Now%20is%20there%20any%20way%20to%20use%20that%20formula%20in%20a%20shape%20that%20I%20can%20use%20as%20a%20button%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1311567%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20different%20sheets%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1311567%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20afraid%20it%20is%20hard%20to%20use%26nbsp%3B%20the%20formula%20to%20make%20a%20botton%2C%20but%20maybe%20you%20can%20set%20the%20color%20for%20the%20cell%20to%20make%20it%20different%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F618946%22%20target%3D%22_blank%22%3E%40sammage34%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a sheet that I can add a lot of dated information to, and then 12 more sheets, one for each month. I would like to have a button with a link set up that will go to the current month sheet. The current month is April, so click on the current month button and it will take me to the April worksheet.

 

Is there a way to do this?

3 Replies
Highlighted

@sammage34 

if the current month April is in the cell "A1"  and you have got the sheet named "April"

you can use the formula: =HYPERLINK("#"&A1&"!A1",A1)

Highlighted

@tbula 

 

That formula works great! Now is there any way to use that formula in a shape that I can use as a button?

 

Highlighted

I am afraid it is hard to use  the formula to make a botton, but maybe you can set the color for the cell to make it different@sammage34