Printing payslips - Please Help!

[rushdhi]

I need to print payslips for our employees as we do not have a dedicated payroll software to do this.

Here is what I want to do. I want to have lower area of the worksheet as a template and the upper area to hold all payroll information and I want Excel to pickup the information from uppaer area and transpose that to the template and print. After printing the record in the 1st row it should move down and repeat until all the records are printed

 

[ThePencilQueen]

Wouldn't it be easier to just do a mail merge in word?

 

[royUK]

What Payroll information is being held in your upper area - is it calculated results for each employee i.e tax deducted, gross pay,net pay etc or is it a tax table for your template to make the deductions from ?
I would think that as tax deductions are being made involving employees wages some dedicated software like Quickbooks Pro or Sage Payroll would be the safest option

 

[rushdhi]

Yes the top area contains calculated results for each employee, such as Gross Pay, Deductions, Netpay for each employee.

Thanks
Rushdhi

On 2002-09-24 04:45, royUK wrote:
What Payroll information is being held in your upper area - is it calculated results for each employee i.e tax deducted, gross pay,net pay etc or is it a tax table for your template to make the deductions from ?
I would think that as tax deductions are being made involving employees wages some dedicated software like Quickbooks Pro or Sage Payroll would be the safest option

 

[royUK]

Hi
This form has Lookups in the blue cells which bring information from the list in the top half of the sheet. Just assign each employee an ID and for each payslip change the ID#. the payslip will update and then you can print.
It should be possible to create a macro to automate the actions
Is this any help?

Roy

Book2
	A	B	C	D	E	F	G	H
1	ID~#	Employee	GrossPay	Deductions	NetPay
2	1	Smith	1000	150	850
3
4
5
6
7
8
9
10
11
12		EmployeeID#	1
13
14		Name	Smith
15
16
17				GrossPay		1000
18				Deductions		150
19
20				Netpay		850
21
22
23
24
25
26
Sheet1

This message was edited by royUK on 2002-09-24 07:11

 

[ThePencilQueen]

Which is exactly what a mail merge will do just without having to fiddle around with macros, you just have to insert the column names (fields) into the word document where you want them and you can print all or a range or one or whatever.

The only hassle is getting the layout you want into word rather than excel.