I am looking for a method to create a HYPERLINK formula that will open a specific workbook when the cell is clicked. The issue I am running into is that I want to be able to link the workbook's name to a specific cell in the original workbook. This is because I have multiple workbooks that need to be hyperlinked to. Below is an example:
Workbook Name = 12345.xlsx
HYPERLINK Function: =HYPERLINK("[C:\Desktop\12345.xlsx]","12345")
Now, onto the problem:
Cell A1 = 12345
Cell A2 = HYPERLINK("[C:\Desktop\A1.xlsx]",A1) - results in an error
Is it even possible to have a cell link in an address?
Thank you.
Bookmarks