Hyperlink

[engmgriff]

Hi

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

Thanks

Mat

 

[copycollie]

Try this:

-select cell A1 and right-click. Choose "hyperlink"
-Choose "Link to place in this document".Now you can select a workshee
and a cell to highlight.

Insert a sheet for each part, repeat for A2:A10.

This should do it.

Kind regards,

copycollie

 

[engmgriff]

Thanks

I have done this but the cell i would like the information to go int
(ie information from cells A1:A10) in the other worksheet does no
appear.

Mat

 

[copycollie]

Maybe I misunderstood. Cell A1:A10 always have the same value?

You can make your targetcell the same as A1 by simply typing

=sheet1!A1

in that cell.


Kind regards,

copycollie

 

[engmgriff]

Cells A1:A10 have different information in and when I press hyperlink on
that particular cell I want it to jump to the other sheet with the
value in the cell which I clicked on.

 

[Dave Peterson]

You have responses at your other post.

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

 

[copycollie]

Matt,

take a look at the attached file please. I hope it will help you.


Regards,

copycolli

Attachment filename: inputsheets.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46707