hyperlink to a cell in another spreadsheet with condition

[ML]

Hi,

I an working on a spreadsheet. I want to create a hyperlink for a cell that
item number is 123456. When I clink on the hyperlink, it will jump to the
rows of another worksheet (worksheet A) in the same workbook that the item
numbers are the same as my current cell. Worksheet A needs to be updated
once a week and the rows will not be the same as it used to be.

Thanks.

 

[ShaneDevenshire]

Hi,

You can hyperlink to a fixed cell address. If you want a hyperlink that
find a value in a list then your hyperlink must run VBA code. If that is
what you want you need to give us more specifics if you want the code. For
example what is the sheet name and what is the range that we need to search
through for the number.