Hi Friends,
I want to print payslips automatically through macros .All payslips should get printed automatically.
I am attaching the sample sheet also pls formulate it.I will be highly greatfull.
Thanks in advance
aparna wangu
Hi Friends,
I want to print payslips automatically through macros .All payslips should get printed automatically.
I am attaching the sample sheet also pls formulate it.I will be highly greatfull.
Thanks in advance
aparna wangu
have a look at this
http://www.excelforum.com/excel-prog...eneration.html
Hi thanks for providing such an useful info but i am very new to VBA as well as macros and i am not able to recognize in demo macro sheet that how to implement the same in my payslip sheet as the cell references will be different.Pls guide me i am really confused.I want that all the payslips should should get stored in pdf file and then i can print the same file.Pls populate the sheet with formulas. I will be highly greatfull.
Thanks in advance.
First, you have to enable Macros on your worksheet.
File > Options > Customize Ribbon > (check-box) Developer
Second, when you save, you have to make sure it's a Macro-Enabled excel file.
File > Save As > [Enter file name] > [Save as type] Excel Macro-Enabled Workbook
Now, this is just a super-basic answer to what you've asked for. The only thing that should be changed, on Sheet2, is the cell C4, which is the Employee ID number. Every other space that does something, looks at that cell on the Sheet1 table and fills in the appropriate information.
If you need to look at the VBA programming, select your sheet:
View > Macros > [choose one] Edit
As you can see on PrintAll, it's just a repeating, so you should be able to copy/paste for your information. I labeled all I could think of to help explain it.
Edit - I don't know how to save to the pdf format, like you wanted, but this populates the Sheet2 and prints one or all, however you choose.
Last edited by Old4xford; 07-09-2015 at 03:13 PM. Reason: Forgot pertenant information
Oh! I get it.
I need rep--->҉
Thank You Thank You Thank You so much.I really appreciate your help.This has resolved a big headache of mine.
Thanks
I want a help actually i add two more lines in payslip but that is not reflecting in the print out.Pls help me out.
One more thing i want a combobox in empid so that i can select the ids from that and print accordingly.
Last edited by aparnawangu; 07-10-2015 at 01:10 AM.
On the example sheet, I restricted the Print Area on the payslip page, for testing purposes. I guess I forgot to remove the restriction. To do that, do the following:
Page Layout (tab) > Print Area > Clear Print Area
I'm not really sure what you mean. Are you asking for a Drop-down list?i want a combobox in empid so that i can select the ids from that and print accordingly.
Click on the Cell you want the list to appear >
Data (tab) > Data Validation > Allow:List ; Source:Sheet1!A2:A5 (of the example given) > Ok
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks