Question

can somebody help me on how to interlink two work sheet of the same workbook using HYPERLINK please?​

Answer 1

Answer:

I have written the cøde for you.

Hope it helps.

Answer 2

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