Hello there!
How can I use "HYPERLINK(link_location, [friendly_name])" with variable workbook and sheet name and spece between their names.
I linked the "[friendly_name]" to sheet name.The argument "[friendly_name]" doesn't allow the hyperlink to work if there's a space between either workbook name or sheet name.
Following are the details:
Workbook name: My Workbook
Sheet name: My Sheet 1
My Sheet 2
I'm trying to link a Cell "A1" on "My Sheet 1" to a Cell "B1" on "My Sheet 2" with the following formula:
=HYPERLINK(CELL("address",'My Sheet 2'!B1),REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),""))
Excel accepts the arguments happily, but when I try to go to cell "B1" in "My Sheet 2" by clicking on Cell "A1" in "My Sheet 1", a box appears saying "Cannot open the specified file"
Hope it makes clear.
Thanking you in advance.
How can I use "HYPERLINK(link_location, [friendly_name])" with variable workbook and sheet name and spece between their names.
I linked the "[friendly_name]" to sheet name.The argument "[friendly_name]" doesn't allow the hyperlink to work if there's a space between either workbook name or sheet name.
Following are the details:
Workbook name: My Workbook
Sheet name: My Sheet 1
My Sheet 2
I'm trying to link a Cell "A1" on "My Sheet 1" to a Cell "B1" on "My Sheet 2" with the following formula:
=HYPERLINK(CELL("address",'My Sheet 2'!B1),REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),""))
Excel accepts the arguments happily, but when I try to go to cell "B1" in "My Sheet 2" by clicking on Cell "A1" in "My Sheet 1", a box appears saying "Cannot open the specified file"
Hope it makes clear.
Thanking you in advance.
