Thank you very much, Chester! Tried to use the Hyperlink function to navigate through multiple sheet, however it didn't work out. After watching your video, I could finally create a button that could navigate me through multiple sheets without any errors. Thank you!
Did everything you did, it work for a moment and then quit working. I deleted all formulas and references and tried to start over but no luck, it wont work at all now and I am following you step by step.
Great video, many thanks. What is the best way to put the drop list on each of the tabs? I have a spreadsheet with many tabs, currenlty there is a link one each back to an Index page. Which contains links to each of the pages. The hyperlink drop-down solution looks/feels far better, so I would like to use this instead
This is a really good turorial, thank you; however despite having been through the process I cannot get the last part to work (ie after inserting INDIRECT) into the named reference; the link simply takes me to the cell A1 on the same tab, for all the links in the dropdown. Oddly excel adds 'CONTENTS! into my named reference: =INDIRECT(ADDRESS(1,1,,,CONTENTS!D18)), and even if I remove it, it puts it back in. Any idea what I'm doing wrong? tia.
Hi, I'm following the exact same steps as you, but when I put my B1cell, which is where my list is, I get an error saying the excel does not understand my formula. Do you know why this happens ?
Hello Chester can you help me . I need to create drop down Value like Yes & NO . Then when some one clicks yes . If some one Clicks Yes Value then yes hyperlink Navigate to the Worksheet . If no Choosen nothing gonna happen . It remain in that Cell . Can you suggest or advice something .
HI A SMALL QUESTION RELATED THIS HYPER+DROP. I LIKE TO DO LINK 114 FILES OF AUDIO WHICH IS SAVE ON DESKTOP. IF ITS WORKING SO PLS LET ME KNOW. THX IN ADVANCE
Thank you very much, Chester! Tried to use the Hyperlink function to navigate through multiple sheet, however it didn't work out. After watching your video, I could finally create a button that could navigate me through multiple sheets without any errors. Thank you!
What an Excel hack! Thanks for sharing!
This video is really great and a must save. Thank you for this!
Did everything you did, it work for a moment and then quit working. I deleted all formulas and references and tried to start over but no luck, it wont work at all now and I am following you step by step.
Amazing!! thank you for the great step by step video!!
Great video and trick, Chester. Liked it! Cheers man.
Great tutorial. Thank you very much!!!
Thanks a lot it worked perfectly, But I have one issue when this sheet is locked the hyperlinks do not work anymore, what is the solution for this
Is it possible to use this to create a link to a sheet from a different workbook?
Great video, many thanks. What is the best way to put the drop list on each of the tabs? I have a spreadsheet with many tabs, currenlty there is a link one each back to an Index page. Which contains links to each of the pages. The hyperlink drop-down solution looks/feels far better, so I would like to use this instead
It was not working for unhide sheets. Is there any posibility to open the unhide sheets also? Please let me know
This is a really good turorial, thank you; however despite having been through the process I cannot get the last part to work (ie after inserting INDIRECT) into the named reference; the link simply takes me to the cell A1 on the same tab, for all the links in the dropdown. Oddly excel adds 'CONTENTS! into my named reference: =INDIRECT(ADDRESS(1,1,,,CONTENTS!D18)), and even if I remove it, it puts it back in. Any idea what I'm doing wrong? tia.
@Phamineed to add another indirect formula where? Im having the same issue
Hi, I'm following the exact same steps as you, but when I put my B1cell, which is where my list is, I get an error saying the excel does not understand my formula. Do you know why this happens ?
how to connect accros another sheet in same folder
Hello Chester can you help me . I need to create drop down Value like Yes & NO . Then when some one clicks yes . If some one Clicks Yes Value then yes hyperlink Navigate to the Worksheet . If no Choosen nothing gonna happen . It remain in that Cell . Can you suggest or advice something .
Is there a google sheets?
HI A SMALL QUESTION RELATED THIS HYPER+DROP. I LIKE TO DO LINK 114 FILES OF AUDIO WHICH IS SAVE ON DESKTOP. IF ITS WORKING SO PLS LET ME KNOW. THX IN ADVANCE
My sheet page doesn't comeup with quotes after entering the formula
Can you do this in google sheets?
HOW ABOUT DROP DOWN LIST - SEARCHABLE AT THE SAME TIME?
This doesn't work when the hyperlink is grayed out and control K doesn't work.