I have one payroll spread sheet, on another sheet is a payslip, i want to link all the necessary details from my payroll sheet to the payslip (like, rate/hour, no of days, overtime, tax and other deductions) can you pls teach me how. because i am always doing it manually every pay day and sometimes because of typing i have made a lot of errors.
Share
Assuming that you are using Excel, you can “link” cells with a simple formula.
Let’s say you have $100 in Sheet1!A1.
If you enter this is in any cell on Sheet2, it will display $100:
=Sheet1!A1
If you enter this, you will see $500:
=5*Sheet1!A1