Nov 11 2019 11:52 AM - edited Nov 11 2019 12:03 PM
I have a workbook containing a list of webpages in the first sheet. I want to be able to click on a cell and be directed to that sheet/tab, viewing the entire sheet, instead of clicking through a workbook with over 25 tabs.
For example, in the attached screenshot, when clicking on the "Homepage content" cell in the first sheet/tab of workbook 1, it will take me to the "Homepage Content" sheet/tab in workbook 1, allowing me to view the entire sheet.
I tried using the hyperlink formula, =HYPERLINK('Homepage Content'!A1,"Homepage Content"), but it doesn't work and have looked through several google search results as well. Any help would be appreciated, thanks!
Nov 11 2019 12:46 PM - edited Nov 11 2019 01:01 PM
SolutionNov 11 2019 01:08 PM
@Abiola1Awesome. It worked! Super thank you and much appreciated.
Nov 11 2019 01:11 PM - edited Nov 11 2019 01:15 PM
Nov 11 2019 01:20 PM
Nov 11 2019 01:28 PM
@Randy Birch Awesome! This worked and was a quicker and easier solution. Thanks!
Nov 11 2019 01:42 PM
Nov 11 2019 12:46 PM - edited Nov 11 2019 01:01 PM
Solution