Switching using Buttons

%3CLINGO-SUB%20id%3D%22lingo-sub-1385055%22%20slang%3D%22en-US%22%3ESwitching%20using%20Buttons%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385055%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20work%20spaces%20in%20a%20spreadsheet%20.1st%20Workbook%20has%20list%20of%20buttons%20with%20hyperlinks.2nd%20is%20list%20.%3C%2FP%3E%3CP%3EI%20need%20a%20help%20where%20in%20when%20I%20click%20the%20button%20with%20hyperlink%2C%20it%20should%20go%20to%202nd%20workbook%20and%20high%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1385055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388329%22%20slang%3D%22en-US%22%3ERe%3A%20Switching%20using%20Buttons%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388329%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F665779%22%20target%3D%22_blank%22%3E%40Vishal1509%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20creating%20bulk%20hyperlinks%20as%20required%20by%20you%20using%26nbsp%3B%3DHYPERLINK%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20a%20try%20and%20if%20something%20goes%20wrong%20we%20are%20here%20to%20sort%20out%20the%20same%20for%20you.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have 2 work spaces in a spreadsheet .1st Workbook has list of buttons with hyperlinks.2nd is list .

I need a help where in when I click the button with hyperlink, it should go to 2nd workbook and high

1 Reply
Highlighted

Hello @Vishal1509

 

You can creating bulk hyperlinks as required by you using =HYPERLINK

 

 

Give a try and if something goes wrong we are here to sort out the same for you.