I'm looking for a way of inserting a formula based hyperlink that when
selected would navigate to a cell in another tab (same workbook) which had
the same name. I know you can insert specific hyperkinks indivudally, but i
have thousands of rows which when clicked on need to navigate to the same
item (based on referrence id in cell) in another sheet??