Forum Discussion
Solved
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 ...
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.
Hi Mary,
If you attach small sample file without sensitive information it'll be easier to help with formula
Hi Sergei,
I just finished watching a tutorial about the basic use of VLOOKUP, tried it and it worked! I know it would take me a little time in updating the Pay Slip Sheet but it's gonna be worth it once I'm done. Thank you so much for your help.