John wrote:
So how do I paste a link based on a value instead of a cell position?


You could name the cell you want to link to (names move with cells when
rows or columns are inserted or deleted; addresses don't).

Or you could use a VLOOKUP formula, in which case it would be wise to
name the table in which you are doing the VLOOKUP

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup