is it possible to generate a payslip in excel?

or if i have a template of payslip in another sheet, then how can i
generate a payslip without linking each cell of a payroll report one by
one? since we have thousands of employees, it's really hard to link
them one by one. thanks a lot!


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=553027

Maybe consider producing the payslip in WORD and doing a mail merge based on
the payroll data in your Excel spreadsheet.

If you do it in Excel, then you (probably) need to write VBA code to loop
through your Excel database and produce the payslips.

HTH

"si_ako" wrote:


is it possible to generate a payslip in excel?

or if i have a template of payslip in another sheet, then how can i
generate a payslip without linking each cell of a payroll report one by
one? since we have thousands of employees, it's really hard to link
them one by one. thanks a lot!


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=553027

Toppers Wrote:
Maybe consider producing the payslip in WORD and doing a mail merge
based on
the payroll data in your Excel spreadsheet.

If you do it in Excel, then you (probably) need to write VBA code to
loop
through your Excel database and produce the payslips.

HTH

"si_ako" wrote:


is it possible to generate a payslip in excel?

or if i have a template of payslip in another sheet, then how can i
generate a payslip without linking each cell of a payroll report one
by
one? since we have thousands of employees, it's really hard to link
them one by one. thanks a lot!


--
si_ako

------------------------------------------------------------------------
si_ako's Profile:
http://www.excelforum.com/member.php...o&userid=35078
View this thread:
http://www.excelforum.com/showthread...hreadid=553027




thanks! how to do the two options? hope you can detail the procedures
and formulas..many thanks!


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=553027

It is difficult to give the answer without detailed knowledge of the data and
format of the pay slip.

Can you post an example spreadsheet showing data and layout/format of payslip?

"si_ako" wrote:


Toppers Wrote:
Maybe consider producing the payslip in WORD and doing a mail merge
based on
the payroll data in your Excel spreadsheet.

If you do it in Excel, then you (probably) need to write VBA code to
loop
through your Excel database and produce the payslips.

HTH

"si_ako" wrote:


is it possible to generate a payslip in excel?

or if i have a template of payslip in another sheet, then how can i
generate a payslip without linking each cell of a payroll report one
by
one? since we have thousands of employees, it's really hard to link
them one by one. thanks a lot!


--
si_ako

------------------------------------------------------------------------
si_ako's Profile:
http://www.excelforum.com/member.php...o&userid=35078
View this thread:
http://www.excelforum.com/showthread...hreadid=553027




thanks! how to do the two options? hope you can detail the procedures
and formulas..many thanks!


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=553027

thanks a lot *Toppers *, here's the example:

For the period June 1-15, 2006
Name RegularDay Basic Pay Adjust Late Overtime Deduction Net Pay
Mr. A 7 2,000 100
2,100

here's the payslip:

Company Name
For the period June 1 - 15, 2006
Name: Mr. A
Regular Day 7
Basic Pay 2,000
Adjustment 100
Total 2,100

Deduction -
Net Pay 2,100


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=553027

If you give me an e-mail address I'll send some samples.

"si_ako" wrote:


thanks a lot *Toppers *, here's the example:

For the period June 1-15, 2006
Name RegularDay Basic Pay Adjust Late Overtime Deduction Net Pay
Mr. A 7 2,000 100
2,100

here's the payslip:

Company Name
For the period June 1 - 15, 2006
Name: Mr. A
Regular Day 7
Basic Pay 2,000
Adjustment 100
Total 2,100

Deduction -
Net Pay 2,100


--
si_ako
------------------------------------------------------------------------
si_ako's Profile: http://www.excelforum.com/member.php...o&userid=35078
View this thread: http://www.excelforum.com/showthread...hreadid=553027