Forum Discussion
Excel Help
Is there a way (either formula or macro /something) for the following. I have 2 different spread sheets (files) open at the same time. First is called Time Card Second is called Wages Time C...
You can do this with a normal hyperlink.
In the Time Card workbook, next to the staff member’s name, add a formula like:
=HYPERLINK("C:\YourFolder\Wages.xlsx#'Payslips'!A25","Open payslip")
This will open the Wages workbook and jump to the specified cell on the Payslips sheet.
For better maintainability, I would suggest creating named ranges in the Wages workbook and linking to those named ranges instead of fixed cell addresses:
=HYPERLINK("C:\YourFolder\Wages.xlsx#Joe_Deer_Payslip","Open payslip")
That way, if the payslip moves, you only need to update the named range rather than every hyperlink.