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.

What software is this you are telling us about ? Googling is quicker than waiting for an answer....

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

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

thanks for the reply derbydad03, and yes its in excel file. I hope i can do it using the formula you gave me.

Why aren't you using a payroll program? If you wish to use the spreadsheet further enhancements can also print the checks as well as the payslip.

excel only

Wizardfriend, i don't know with the management, that's how they do it eversince, at least now little by little i can be able to link the payroll file into the payslip, so i dont have to type all the details all over again.

Ask Your Question

Weekly Poll