I am trying to create a dynamic hyperlink or Macro which looks at a cell reference in a cell and goes to that cell in a different tab in the same file.
EG
I have a Tab called "TB" with numerous GL Codes in col A. In Column F I have created the cell address. There is a tab for each code. I...