Forum Discussion
Solved
Creating hyperlink
Hello All,
Hello ,
I am trying to create hyperlink from sheet 1 to jump to another sheet within a range. For example, in the given sheet 1, there are values like First , Second and Third to jump to the values which sits in another sheet. In given below image , I want to click Value first and it should direct me to sheet 2 "This is a first line". I want to use this hyperlink to use other values to perform similar task as it did in First case. I tried to use built in hyperlink function to no avail.
Regrds
Hi AlokBeheria
you have a comma after the ] that needs to be removed:
Instead of
=HYPERLINK("[hyperlink_test.xlsx],Sheet1!A2","title")
it should be
=HYPERLINK("[hyperlink_test.xlsx]Sheet1!A2","title")
Hi AlokBeheria
if you want to use the HYPERLINK function to jump to another sheet within the same workbook, you need to include the filename in the link address and put everything in quotation marks:
=HYPERLINK("[Creating_hyperlink.xlsx]Sheet2!A2","Title")
@Mart : Thanks a ton ! Your inputs helped me.
Regards
