Excel Help

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.