can somebody help me on how to interlink two work sheet of the same workbook using HYPERLINK please?
Answers
Answered by
0
Answer:
I have written the cøde for you.
Hope it helps.
Attachments:
![](https://hi-static.z-dn.net/files/d1f/b5c1e89dbcd6df94a0ed4739b8e927b8.jpg)
Answered by
0
Answer:
1.Select a cell in one sheet that you want to create a hyperlink to another sheet, and click Insert > Hyperlink.
2. In the Insert Hyperlink dialog box, please do as follows:
(1) Click the Place in This Document button in the Link to box;
(2) Select one sheet that you want to hyperlink to in the Or select a place in this document box;
(3) Enter the text you want to display for the hyperlink in the Text to display;
(4) If you want to hyperlink to specific data in the sheet, please specify the cell in the Type the cell reference.
3. Click OK.
Then the selected cell is added a hyperlink to the specific cell of specific worksheet in the same workbook.
please mark this answer as brain list
Similar questions