Automatic Salary Slip Generator using Excel

Hi,

A very quick (probably dirty too) solution is as follows:

1. Use the FILE->PAGE SETUP option and click the SHEET tab and set "ROWS TO REPEAT AT TOP" as the column-heading of your EXCEL Worksheet. Press OK button after you have done it.

2. Now launch the FILE->PRINT PREVIEW option and click the button named MARGIN. (You will see this button on the top).

3. We will now set the margin to print only one record per page. To do this pull the Top Margin indicator thread downwards and then pull the Bottom Margin indicator thread upwards. Note that the print preview shows one record and column heading in each page. Do cycle through the records by clicking the NEXT button and satisfy yourself about the format before printing.

Suggestion: To save pages, you can save the printout to a text file, open this saved file using an editor and replace the PAGE BREAK characters by couple of NEW-LINE CHARACTERS or by a simple continuous line (“-------”) to act as separator between records. (Do this only if you are comfortable with the process.)

A neat solution would be to use Excel Macros (using VBA or VB) or to import the data from your worksheet into a database and then programe the printout as desired.

Hope this helps.

Hi

Thanks for the reply friend.I will check it out.

Anyone who have other ideas about this subject.Please share it...

Regards

BINUMS

HI

HAVE U ANY IDEA ABOUT MS.ACCESS? IF YES THEN USING LINKING OPTION U CAN GENERATE & MANAGE SALARY SLIP WITH BEST ACCURACY. IN EXCEL U WILL FACE  PROBLEMS 2 MANAGE REPORT. i.e. salary slip

regards

Hi all

I am agree with vikas, nice suggestion to use MS ACCESS.

Good

Dear all

First of all Thanks for the reply.Both of you are suggesting MS Access is

better option for generating salary slips than Excel.My Idea is based on a Excel

Sheet that will have serial no of employees,their emp.code ,Basic,HRA

other deductions etc.So now how we can automatically generate Salary slips

based on the  employee serial number.If you are suggesting MS Access is

good idea please tell me how we can link MS Acess with that Excel sheet or

if  you have any other ideas also using excel please share it. 

Regards

BINUMS

thanks

Mr.Nitin

After lot of discussions with lot of people I found MS office template ie,

payroll calculator.xls is useful for automatic preparation of salary

statements.If you want that template please download it from Microsoft

website...That will be helpful

dear sir,

i need a salary slip format .

please provide us

thanking you

deepak kumar

Payroll Processing Software in excel,

for this i need the functionality of storing data in some permanent file, making updations etc

so gong step by step first of all i want to know how to store data in excel / in database thru excel. Automatic salary Calculation & All Type Report Geberator in Ms Excelneratalary Slip Generator using Excel
Please send me file attached in Excel Format

hi

please sent me a excel formate salary register

i need a format of salary slip .plz can you send to me or help me

Salary Register, Payslip, Attendance Register, Payroll Voucher