I have 2 workbooks that are linked to one another with multiple links. In book one you have links to book 2 and in book 2 you have return links to book 1. (Kind of like a webpage). Well if you insert a line(s) into book 1, all the return links after the inserted lines are off by how ever many lines were added. Anyway to keep the return links from book 2 locked to the destination cells in book 1 even if you add more lines. Would be a big help.
Thanks, rick
Thanks, rick