T
tkraju via OfficeKB.com
I have a w/sheet (SalaryMaster) ,each row contains salary details of
employees,with 20 fields(column headers).I have designed a salary slip as a
template in other sheet,with all the above 20 fields.How to print salary
slips of each employee from that w/sheet, 2nd row to end row ,in the way I
have designed salary slip.
my pay slip design is a bit like this:
B2
2(merged)=Company's Name say ABC corporation,E2:F2=Address Of company
Both are headers to repeat in every page
B33=Salary Details of E3=SalaryMaster!C2(Month and year field)
B4=Employee Id,C44=Employee Name,E4=Designation
D5=SalaryMaster!D2(DaysWorked)
E5=salaryMaster!E2(withoutPay Days)
B6=SalaryMaster!F2(BasicPay0
Thanks in anticipating proper solution
employees,with 20 fields(column headers).I have designed a salary slip as a
template in other sheet,with all the above 20 fields.How to print salary
slips of each employee from that w/sheet, 2nd row to end row ,in the way I
have designed salary slip.
my pay slip design is a bit like this:
B2
2(merged)=Company's Name say ABC corporation,E2:F2=Address Of companyBoth are headers to repeat in every page
B3
3=Salary Details of E3=SalaryMaster!C2(Month and year field)B4=Employee Id,C4
4=Employee Name,E4=DesignationD5=SalaryMaster!D2(DaysWorked)
E5=salaryMaster!E2(withoutPay Days)
B6=SalaryMaster!F2(BasicPay0
Thanks in anticipating proper solution