Hyperlink to word instead of cell

[CharlieK]

Hopefully this is the right place to post this?

Is it possible to point a hyperlink to a word, rather than a cell?

I have a workbook made up of approx. 200 work sheets. The first worksheet is a master price list, for both raw materials and manufactured items. The following sheets are cutting lists/work orders/BOM's for the items listed on the first sheet. Each sheet uses raw material prices off of the first sheet, and the pricing that each sheet develops is displayed on 'its' sheet, and also again on the first sheet.

Each sheet has a 'Back' link, that is set to go back to its titled cell on the first sheet. Except, whenever new rows are added in the first sheet, to make room for more items, the link from the sheet still brings you back to the same cell, even though all of the cells have been shifted down... meaning you are not in the right place. If its possible to make a hyperlink to a word instead of a cell, then it should follow it? Or is there something else I'm missing?

Hopefully this makes sense!

Windows 7
Excel 2013

Thanks,
Charlie

[DBY]

Hello Charlie welcome to the forum.

You can use the HYPERLINK function to have a variable target, for example:

Please Login or Register  to view this content.

This would find the first instance of the text "Find me!" in column A on Sheet 1, even if rows are inserted or deleted. Also it might be a good idea to limit the range from an entire column if possible, if you know the likely extent of the range to search.

DBY

[CharlieK]

Any chance I can get you to re-write that? I can't get it to work...

Name of the first sheet: Steel Prices
Name of the word its looking for: Gman2ydSpec
Column it will be in: I

Thanks for the help!

[avk]

Attach file for your ready reference.
You can made changes accordingly.
Hope this hopefull for you.

[DBY]

Hello

AVK's file shows how this works when linking to a file. However, specifically in this case, your formula could be adjusted to:

Please Login or Register  to view this content.

Hope this works.

DBY

[avk]

Hello

AVK's file shows how this works when linking to a file. However, specifically in this case, your formula could be adjusted to:

Please Login or Register  to view this content.

Hope this works.

DBY

yes thats, as per file name & folder path.