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...
Yes, this is definitely possible. You don't need a macro unless you want full automation. If each employee has a dedicated payslip section or worksheet in the Wages workbook, you can create hyperlinks from the Time Card workbook that jump directly to the correct payslip. If the destination varies dynamically, a small VBA macro using Application.Goto or FollowHyperlink can take the user straight to the matching employee's payslip with a single click. This approach is simple, fast, and easy to maintain.