I am trying to link many cells on one worksheet to corresponding cells on
another. I have two worksheets, one with item price information and another
with physical item information. Both sheets share a common "number" field.
Each item has unique number that is referenced on both sheets. I want to
set up a hyperlink so that when the when any cell in the number field in the
price file is clicked, it lgoes to the cell with that same value in the
number field on the other sheet. I can do this by one cell at a time by
right clicking the cell, adding the hyperlink and setting the destination but
I need to do this for many files with lists over 5000 items long and need to
find a way to automate it. Any help would be appreciated.