Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Customised printing
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:D2(merged)=Company's Name say ABC corporation,E2:F2=Address Of company Both are headers to repeat in every page B3:D3=Salary Details of E3=SalaryMaster!C2(Month and year field) B4=Employee Id,C4:D4=Employee Name,E4=Designation D5=SalaryMaster!D2(DaysWorked) E5=salaryMaster!E2(withoutPay Days) B6=SalaryMaster!F2(BasicPay0 Thanks in anticipating proper solution -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200905/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
customised userform | Excel Programming | |||
customised output | Excel Discussion (Misc queries) | |||
customised printing of multiple pivot charts & tables - unsure how to progress | Excel Programming | |||
customised sheet | Excel Programming | |||
Customised Interface | Excel Programming |