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

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

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.

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

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

I'm really beginning to love this channel

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

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!

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

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

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

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?

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

Could y please advice me if i would to autoprint.

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

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?

It Works... Amazing

Very Nice Presentation

GOOD INFORMATION

Many thaaaaank

Can you do reverse 🔄 payslip to data row

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

Needed this exactly some months ago😂

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

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

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

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

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

Are you using office 365? My dropdown cant be automated

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

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? 

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

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

I did the same output using excel and word mail merge

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

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

Please I want to know the starting part of it

Not working Run time error 424

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

Payslip pdf with password

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