Hyperlink

[engmgriff]

Hi

I have a spreadsheet which has part numbers listed (A1:A10), I would
like to set up a hyperlink so that when I press one of these numbers it
will jump to another cell in the workbook and highlight this number in
a specified cell. Therefore when I press any number from these cells
it jumps to the required sheet and uses the number from the hyperlink.


Thanks

Matt

 

[David McRitchie]

Hi Matt,
I have a some pages on HYPERLINKS
http://www.mvps.org/dmcritchie/excel/sheets.htm
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

Not sure what you are asking, a hyperlink only transfers you to another
cell it does not change values anywhere. You can reference another
cell to obtain the value of another cell.just like you use =Sheet1!G3

You can use an object hyperlink to refer to another cell
On your sheet enter your =Sheet1!G3
What you see when you enter an object hyperlink will vary slightly
depending on your version of Excel, I have Excel 2000.
Right click on cell, choose Hyperlink
Edit Hyperlink
type the cell reference: A1
place in this document: select sheet i.e. Sheet1

You can use a HYPERLINK Worksheet Formula (which I prefer)
to refer the cell content in Sheet1!G3 and link to cell Sheet1!A3
=HYPERLINK("sheet1!A3",Sheet1!G3)
but note the double quotes, if you change the location by inserting/
deleting rows/columns what is in quotes remains unchanged.
There is a solution to that, so that the address is not in quotes:
=HYPERLINK("#"&cell("address",Sheet1!A3,Sheet1!G3)

If you are using hyperlinks you can use the Forward (Alt+ArrowRt)
and Back (Alt+ArrowLt) buttons just like in your browser, your can
install these buttons on your Excel toolbar:
Tools, Customize, Commands (tab), Web, then drag the buttons
on the right side you want add to where you want them on your toolbar.