I am trying to link a whole range of cells to another range of cells in another sheet within the same workbook. I tried following https://superuser.com/questions/452742/copying-a-hyperlink-so-that-it-works-with-a-series and ended up using the formula
but it seems the reference still remains absolute in the sense that after I drag it down the column, all cells still link the the same cell in the other sheet rather than smartly adjusting to keep descending down the column.
What did I mess up? The boss is adamant that the cells have to link back to the originating data, and while I could go line for line correcting the references, its is several hundred lines so I would prefer not to.
Code:
=HYPERLINK("#"&ADDRESS(ROW(A3),COLUMN(A3), 4, 1, "LSOC"),LSOC!A3)
What did I mess up? The boss is adamant that the cells have to link back to the originating data, and while I could go line for line correcting the references, its is several hundred lines so I would prefer not to.