How to get fill row count

Closed
Datta patil - Jan 31, 2009 at 05:21 AM
 trynToHlp - Feb 3, 2009 at 08:18 PM
Hello,

i have one workbook. In this there are various sheets.
First sheet is "Summary". On this there is one column it contains the names of each sheet.

Now, i want to assign a hyper link to every cell that contains the name of sheets. So that on summary tab if i click on sheet name in the cell, i should be jumped to that sheet.


Thanks...

1 response

Right click on the cell where you want to create the hyperlink.
On the drop down menu, select Hyperlink.
The Insert Hyperlink dialog box will open.
The heading on the left side will say link to. Select - Place in This Document.
Now select the sheet you want the hyperlink to "jump" to.
Also, where it says - Type cell reference, type the exact the cell reference within the sheet you selected.
Click ok on the bottom right of the dialog box.
You are done.
Repeat the process for each hyperlink you want to add.
2