I am trying to link based on a text value instead of cell position
I am trying to link from one workbook to another.
The source position changes, for example product 121.1 might be one cell
lower because a product 120.1 was added.
So how do I paste a link based on a value instead of a cell position?
Thank you for any information
John
|