Forum Discussion
How to Create a Link in a Cell to Jump to another Worksheet
Ok, hopefully this is a simple request. I am expecting to have a large number of Worksheets (Invoices) in one Workbook, to which the First sheet is a Catalog list of those Invoices. I want to be able to provide a link in a Cell to that Worksheet, so it's easy to bounce to that invoice. The closest thing I found in the Help tab to do this is this formula:
So I subbed the Workbook name for mine, and the "Sheet1!" with the Contents of the Cell to the left that has the name of that Worksheet. This code would then be copied to each line that a new invoice would be entered, without having to edit the code each line, cause it would take on the name in the referenced Cell.
=HYPERLINK("[Work Invoice & Log.xlsx]B5!A1",B5)
The Cell B5 has the Name of the Worksheet Tab I want to jump to. I really don't need to call a specific Cell, but I left the A1 after the sheet call in there. Not sure if I need that at all. At any rate, It's not working, and tells me my Link is invalid. I'm probably missing something very simple.
Thanks in Advance.