If you know all the worksheet names and you want to create hyperlinks to activate the worksheet with formula. Snapshot Below-
Formula in cell b2 = HYPERLINK("#"&A2&"!a1","Click Here to View")
Formula in cell I2 = HYPERLINK("#"&H2&"!a1","Click Here to View "&H2)
Download the file Click Here
No comments:
Post a Comment