Hyperlinks

[SantasLittleHelper]

I have a list on a sheet with lots of different names of organisations.

E.g.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Cell Value[/TD]
[TD]Cell[/TD]
[/TR]
[TR]
[TD]ORGANISATION 1[/TD]
[TD]A1[/TD]
[/TR]
[TR]
[TD]ORGANISATION 2[/TD]
[TD]A2[/TD]
[/TR]
[TR]
[TD]ORGANISATION 3[/TD]
[TD]A3[/TD]
[/TR]
</tbody>[/TABLE]

Is it possible to have a hyperlink so that when the user clicks on the Cell Value, it takes them to a different sheet within the workbook where the cell value is the same?

E.g. User Clicks on 'ORGANISATION 1' (A1) in Sheet1 which takes them to the cell containing 'ORGANISATION 1' (B1) in Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Cell Value[/TD]
[TD]Cell[/TD]
[/TR]
[TR]
[TD]ORGANISATION 1[/TD]
[TD]B1[/TD]
[/TR]
[TR]
[TD]ORGANISATION 2[/TD]
[TD]B2[/TD]
[/TR]
[TR]
[TD]ORGANISATION 3[/TD]
[TD]B3[/TD]
[/TR]
</tbody>[/TABLE]

 

[JazzSP8]

To create the hyperlink then select the cell you want to be the hyperlink and press CTRL & K

This will bring up the "Insert Hyperlink" dialog box.

On the left hand side select "Place in this Document"

This will allow you to select a sheet from the workbook, you can enter the cell reference manually in the text box above it (or you can define names etc.)

HTH

 

[SantasLittleHelper]

Thanks for this.

I know how to Hyperlink but as I have a list of approximately 50 organisations, I am wondering if there is a way around manually setting the hyperlink for each cell?

 

[Yongle]

Hi
With first name in A1, place this formula in B1 and copy down

=HYPERLINK("#Sheet2!"&ADDRESS(MATCH(A1,Sheet2!B:B),2),A1)

 

[JazzSP8]

There is a HYPERLINK formula as well

=HYPERLINK(Sheet2!B1,"Text to Display")

 

[Yongle]

you could also try this in cell A1 copied down

=HYPERLINK("#Sheet2!"&CELL("address",B1),Sheet2!B1)