Hyperlinking Records in Excel in 2 separte workbooks

I am wanting to link two workbook files located outside a workbook using hyperlinks but line#'s change when I add or delete a line. Eg. 12345 record in WB1 hyperlink to 12345 in WB2.

Hope you can help. Greg

Recent Questions...