How to Create Automated Pay Slip in Excel and Save PDF Copy

[@Excel10tutorial]

Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/4aXyOdV

[@patllantino2181]

Thank you for this :* it helps me a lot in creating my payslip :*

[@Suresh-si8ny]

can you share excel file

[@Excel10tutorial]

Glad It works for you.

[@Excel10tutorial]

You'll have to create your own using the instructions.

[@ismaelabubakarali]

Thank you. With a team of 80 employees without a payroll system. I am a happy man.

[@Excel10tutorial]

Doing a great job.

[@cheruLA]

What i have learned from this tutorial is way way amazing ,grated my accounting background,this is a big boost in totality-from Kenya with thanks.

[@Excel10tutorial]

Awesome. Glad I could help. Tell me what type of projects you need frequently in your field. I'll try to create those in excel. I'd love to contribute to your field. Thanks

[@nsubugakenneth7390]

I'm really beginning to love this channel

[@Excel10tutorial]

You just made my day. Thanks a million.

[@jayaashokkumar2779]

Tq a lot sir I have done successfully 🎉 Tq Tq Tq sir

[@Excel10tutorial]

All the best

[@VinodKumar-3]

Very good tutorial. However, if we have data for multiple months in Data sheel, what changes are needed for this to work?

[@bollinaaruna5794]

Hi, This video has been very useful. I am able to convert to PDF now only issue how to send this pdf files into employees email id . hope I will see soon a video

[@devias7738]

YOU EARN A SUB, MAN! THANK YOU SO MUCH!!!!

[@Excel10tutorial]

Lovely. Thanks for the sub!

[@IkramKhan-lo3bw]

Sir tried it multiple times but it gives me an error like: Run time Error ' -2147024773 (8007007b)': Document not saved. END. DEBUG Plz guide.

[@rayzor07]

I like this and it gives me more ideas to develop it further as it has a couple of limitations. I don't know VBA, but I can probably learn. Thanks for this!

[@Excel10tutorial]

Go for it!

[@kinderland5353]

It Works... Amazing

[@Excel10tutorial]

Glad to hear that

[@kittuthegreat1819]

excellent video ..thanks for showing this .. i created one :)

[@Excel10tutorial]

Glad you like it. Please subscribe and share.

[@MANANPATEL_2214]

@@Excel10tutorial e sheet milega ready

[@eswargangadhar]

GOOD INFORMATION

[@Excel10tutorial]

Thanks

[@sudhakarc7501]

Very Nice Presentation

[@Excel10tutorial]

Thanks a lot. Please subscribe and be with us.

[@mohammedgammash]

Could y please advice me if i would to autoprint.

[@kumareshs1103]

Sir very clear explained and i need another one video is this pdf employee individual email id auto send how is ,please make video sir ,its very useful sir,thank you sir,kindly email send video need sir

[@Excel10tutorial]

Will upload soon

[@kasturiranganp]

Excellent video! Can you also do a tutorial on how to automate to send emails?

[@Excel10tutorial]

Yes, soon

[@eliaskasongo4789]

This was really useful, Thanks! I need a full HR worksheet, can we work something out?

[@Excel10tutorial]

Sure thing!

[@eliaskasongo4789]

What is you email?@@Excel10tutorial

[@ShawStartDaycareLearningCentre]

Love the video! How to save the pdf with employee's ID, name and date?

[@ismaelabubakarali]

It is already saved in your PC.

[@StarLightAneetta]

In vba what is for I = means

[@Excel10tutorial]

its the variable name used in for loop

[@billvanoudtshoorn5962]

Love this! Made my own and it works just fine. It would be good if it did the monthly salaries and collected the YTD and Annual figures. As it is, you would have to do a separate workbook for each month and collate the figures from there? Do you have an easier solution?

[@Excel10tutorial]

Send me your workbooks with instructions. I'll see what i can do for you.

[@cookingwithfluffytiny4371]

Can you do reverse 🔄 payslip to data row

[@Excel10tutorial]

From pdf?

[@yasminefakhr8668]

Many thaaaaank

[@Excel10tutorial]

You're most welcome

[@DuncansLandscaping-v8j]

Hi! Thank you for this! If this is created in Excel / WPS Office, can it be opened with Google Sheets and not have any errors?

[@Excel10tutorial]

It will work only on excel desktop as it has vba.

[@ariannel.javier335]

I keep getting a run time error - Document not saved. How do I fix this?

[@Excel10tutorial]

Save the workbook before doing this.

[@Shadow-Presentations]

Needed this exactly some months ago😂

[@Excel10tutorial]

Better late than never 😜

[@MsJoy-gu9sf]

im lost, where do you click to get the extra match to select FALSE?

[@Excel10tutorial]

add comma to go to the next parameter.

[@nguyenucanh9694]

Hello. I want the pdf file to have a password added. Do you have any ideas to help me? Thank u so much !!!

[@udarkhan274]

I need practice but i havnt data of employees income to make pay slip . So how can i practice ?

[@Excel10tutorial]

Check online for practice data

[@gicygeorge5596]

Thank you so much. The same is possible with JavaScript for Google sheet? If poosible for Google shhet, please explain.

[@Excel10tutorial]

Sorry, I don't have anything on google sheet

[@HenryJohn-n3z]

Thanks for this tutorial. But pls show also hoe to delete as well..

[@Excel10tutorial]

What do you want to delete?

[@itsmethaphy6322]

if you connect your computer to a printer, will it print the pdfs directly?

[@Excel10tutorial]

This will not print automatically. For printing we need to do things a little bit differently.

[@itsmethaphy6322]

@@Excel10tutorial like using the command 'printout'. I mean, The second statement we write 'sheet1.exportasfixedformat' instead we write 'sheet1.printout'?

[@itsmethaphy6322]

@@Excel10tutorial short video for that will be appreciated

[@theline3]

I ran into a problem, month and year vlookup problem in salary slip? not add Automatic month and year in Salary slip. there is show many number like, 43576 / how to solve this? 

[@Excel10tutorial]

Format them as dates.

[@bhavna2208]

Hello. I am on mac and I am using the free version of WPS office, how can I add the developer tab? Thank you

[@Excel10tutorial]

You can add developer tab on Microsoft Excel.

[@BaliwagTransit-nh6zs]

I did the same output using excel and word mail merge

[@Excel10tutorial]

Awesome

[@PathologicalResearcher]

Are you using office 365? My dropdown cant be automated

[@Sampsonoff]

You must login to excel through a browser, the app even on tablet is limited

[@RealisticMomdaughters]

Sheet1.Range("B11").Value = Sheet2.Cells(i, "A") when running the macro code suggested above line is appearing in yellow.

[@ffbynum]

Check the name of the sheet reference. That can create an error message. See the sheet names in the VB code

[@mwaledex]

did manage to debug or resolve the line?

[@fhussainmomin268]

Sir...how to print ..15 slip in one A4 page ...

[@shajibhossan5661]

How to put this one $

[@atebabawaemmanuel7060]

Please I want to know the starting part of it

[@Excel10tutorial]

This is it.

[@santhoshrajpn3910]

Not working Run time error 424

[@STREVEN-d2w]

Sir, This is amazing..can i have your moblie number,as i tried as ahown in the video ,showing yellow color

[@Excel10tutorial]

Send me an email

[@Anisha-rp4rb]

Mujhe banwana hai.. koi bana sakta hai please??

[@ramanathanswaminathan9489]

Payslip pdf with password

[@Excel10tutorial]

With work on it

[@kasakasa8817]

not workingSheet1.ExportAsFixedFormat xlTypePDF, "D:\Payslip\" & Sheet1.Range("b6").Value & ".pdf"

[@Excel10tutorial]

Change the file path according your need