Forum Discussion

Mary Joyce Tayag's avatar
Mary Joyce Tayag
Copper Contributor
Mar 15, 2018

Locking cell value connected to a different workbook

Hello, I am currently using excel 2010 for our weekly payroll. As of now, I have 2 workbooks. First is where I input the workers daily attendance and overtime which also computes the total salary ...
  • SergeiBaklan's avatar
    Mar 15, 2018

    Hi Mary,

     

    Depends on how your data is structured. As variant, instead of references you may use VLOOKUP() from payslip on salaries list using Worker ID or like.

Resources