payroll sheet how to link to payslip

March 13, 2012 at 17:42:40
Specs: Windows 7
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.

See More: payroll sheet how to link to payslip

March 13, 2012 at 23:15:21
What software is this you are telling us about ?

Googling is quicker than waiting for an answer....

Report •

March 14, 2012 at 05:12:49
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:


If you enter this, you will see $500:


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

Report •

March 14, 2012 at 15:47:01
thanks for the reply derbydad03, and yes its in excel file. I hope i can do it using the formula you gave me.

Report •

Related Solutions

March 15, 2012 at 03:08:12
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.

Report •

March 15, 2012 at 22:24:20
excel only

Report •

March 15, 2012 at 22:26:55
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.

Report •

Ask Question