automate Microsoft Excel Company Payroll, generate employee pay slip PDF with VBA Macros Hindi Urdu

In this video you will learn how to create company salary slip automatically and how to automate the process of generating PDF from Excel with VBA Macros..
After watching this video you will be able to answer the following:
1) How to create salary slip in Microsoft Excel?
2) How to Run Payroll in Microsoft Excel?
3) How to Generate Employee Salary Slip in PDF from Excel?
4) How to automate in Excel?
5) How to use VBA Macros in Excel?
6) How to Generate PDF in Excel?
7) How to use Data validation?
8) How to make salary slip?
9) how to make automated pay slip ?
This Video is essential to watch for every person including students, officers and business person.
Download File:
downloadexcelfile.com/product...
Please subscribe to this channel
For More Videos: kzbin.info?s...
visit: www.exceldoers.com/newsletter/
Facebook page / exceldoers
For Queries & Business: [e-mail]
#Excel #Payroll #PDF #VLookup #PDFtoExcel #PDF #VBA #Macros #MicrosoftExcel #automate #Report #card #Datavalidation #Company #Office #MSExcel #Excel #Autiomation #PrintPDF #Salary #accounting #Tb #Salaryslip #Pay #Roll #Employee #Salary #slipknot
how to sort data in excel
vlookup
excel
excel sort
how to alphabetize in excel
how to arrange data in excel
how to match two columns in excel
how to sort in excel
pivot table excel
vlookup in excel
alignment excel
choose function in excel
combine excel sheets into one
compare two columns in excel
compare two excel worksheets
data sorting in excel
excel all formulas
excel compare two columns for matches and differences
excel duplicate formula
excel index match
excel linking cells sorting
excel shortcuts
excel tablet uses
how to align in excel
how to compare two columns in excel
how to do vlookups on excel
how to match data in excel from 2 worksheets
match columns in excel
match function
match function in excel
match the columns
short in excel
sort
sort data in excel
sort list
v look up
vlookup and match in excel
vlookup between two worksheets
accounting in excel
bookkeeping
excel accounting
excel for accounting
ledger in excel
accounting
book keeping & accountancy
accountant work in office
accounting excel
ledger accounts
journal entries accounting
excel accounting software
ledger account
excel accounting tutorial
excel
ledger
book keeping
how to make ledger in excel
excel ledger
trial balance
excel data entry work
accounts in excel
ledger entry
how to make ledger from journal entries
general ledger
balance sheet accounting
bookkeeping in excel
how to use excel for accounting
accounting software
day book accounting
excel for accounting and finance
bookkeeping excel
balance sheet
general ledger and trial balance
accounting journal entries
account ledger entry
excel for accountants
how to make ledger
ledger book
balance sheet in excel
excel automation
free accounting software
cash book accounting
accounts work in office
how to do bookkeeping
cash book in excel
how to create ledger in excel
journal ledger and trial balance
cash book
pivot table excel

[@mohamadaasif4619]

So Great Of You…. Thankyou So Much❤️❤️❤️❤️ You make my Job so Easier…… ❤️❤️❤️❤️

[@minhajabbasy9582]

Wonderfully explained. Superb👍👍👍👍

[@RajeshKumar-sb7qn]

Thanks a lot. You are a life saver. This is working fantastic

[@yesiunderstand6044]

Excellent bro. Kudos from Kerala, India

[@gmailaccount9169]

Thanks a Lot.Perfect guide

[@IrshadKhan-rk8jz]

really amazing its make my work more easy and more accurate

[@abdullahquhtani4247]

Good job. You can extend this tutorial and take it one step further if you give the user the ability to send pdf to employee email. It needs few modifications.

[@muhammadqasim1871]

awesome....very well taught.... Thank you very much sir... Love you

[@billubaba8413]

Shukriya , very important and informative

[@MrGulfam-fi5fh]

Really Appreciate your Work. It's easy to understand and make every point clear. Thanks alot.

[@EXCELDOERS]

Thanks.

[@fuuastpk]

Excellent content precious

[@stsfunny8408]

Complete bnayeen jis main har cheez hn employ inventry harcheez Apne buhat acaha samjaye

[@waynepolout6574]

Thank you very much. Appreciate the work you put into creating this tutorial

[@EXCELDOERS]

Most welcome. Share with your friends

[@MalluAccounts]

Love from Kerala ,India 😍😍♥️

[@cookneat4523]

Thank You Buddy. Jazakallah

[@hamzazahoor8800]

MaShaAllah great

[@nileshjogiexcelexpert]

Excellent video sir Sir aapse ek request thi ... Jese marksheet print karte hai to roll number to roll number tak matlab ek particular range dekar ek sath kese print kare pls is formula par video banaye

[@jahankhan7238]

Yes I very much like this tutorial.

[@shreeram3741]

Bhai, good information

[@bholuuinc9589]

thank you so much bhai

[@AhmedAli-ci4xy]

it works perfectly! Thankyou so much !

[@infotouch9668]

but on my side its not working :(

[@VinniR007]

thanks for sharing

[@eagledeliveryservicesl.l.c4194]

its realy amazing & i tried it on excel but add a video for gsheet imean how to creat salary pdf's on gsheet in one click

[@naman881]

You are a excel hero, subscribed you

[@EXCELDOERS]

loves

[@naman881]

@@EXCELDOERS ye code kaam kiya aur save and print bhi hua but mujhe aisa code chahiye jo folder ko banaye usme file save kare, aur agar fir se print command diya jaye to pichle saved files ko replace kar de, saath hi saath ye excel file computer me jis bhi drive me ya pendrive me save ho folder automatically usi jagah bane

[@EXCELDOERS]

@@naman881 u can buy my paid service to design custom for u

[@izaanhasan8157]

Appreciated 👍

[@wassupbeauty7331]

That’s awesome, will definitely try this.I have one question, can we do this in word? I have increment letters of all employees in one single word. How can I save them individually by their respective employee code.

[@hitmartstore]

zabrdast

[@adnanabbasi9482]

This is a very informative and helpful video on Payroll and Payslips. You may add the technique to a more robust process of Payroll Data if the last row is dynamic (in the for loop). I hope you will discuss the technique in your upcoming videos. 👍

[@priyanthagamini3860]

Excellent work ❤️❤️ can you please explain, how to set a password to each pdf file in vba (or while generating pdf file)

[@akbaralishaikh3288]

Thank you dear

[@nursam2354]

good work

[@asimahmadani]

Weldone Sir

[@learningenglishpoint3872]

Nice sir

[@markbrianchua1]

Lifesaver.

[@bilalcheema8870]

thanks..

[@muqaddasraza5346]

Very good and informative for us…. Plz share the how to send the pdf payslip all employees on one click with review options

[@nadahkhi]

Good Job

[@thethapa77]

That's Wonderful ! This is for Windows OS but I tried on Macbook but the VBA Macros is not working. Looking for your guideline. Thank you.

[@EXCELDOERS]

Vba works but mac requires different approach in code. Vba macros are usually works best on window

[@deepaksingh-xg7xb]

Thanks a lot, working fantastic, can we generate excel file format same like pdf

[@atikwarsi4819]

Sir Jee, This payslip is perfect but still we need to add one things. One line should be number of working days and i should automatically calculate payable amount according to the number of working days. Many employee join at middle of month. Please modify in same format. Thanks

[@Mannabhav]

🙏💐🙏

[@sahebraophalke6986]

बहुत अच्छा, आपका यह व्हिडिओ देखकर मैने एकसाथ 132 सुपप्लिमेंटरी बील बणाया, लेकिन हर बील का अलग अलग pdf file बना, मुझे सभी 132 pdf file का combine एक pdf बनवाना है, कृपया उसकेलिए व्हिडीओ बनवाइये,,, धन्यवाद

[@discoverindia2475]

Very nice and short VB script Muze password bhi dena hai pdf file to depend upon id and name to

[@EXCELDOERS]

need to check acrobat add in for it.

[@kameshmalviya5534]

Dear sir, agar mere pas employee no. Sequence me nhi hai or six digit employee no. Hai sare alag hai to vb me konsa syntax use hoga

[@kiransuryawanshi3792]

Please share excel file because of your working is very fast I can understand...

[@modnocslair5661]

Hi thank you for this..I have a request how about send to employee email automatically?

[@beekayautopvtltd8521]

Can you pl share a code as to how to share these pdf files to respective email ids ?

[@shreeram3741]

Bhai, agr 1000 employees ki pay slip generate krke unki mail par keise bheje ek sath is par b bataiye

[@chronicto1]

Good job. Please can you send me the file

[@mailtobasava]

@EXCEL DOERS please provide the file, I have subscribed your channel

[@kiranarana7274]

Please help wat wil be the vba if I would like save pdf file on range(“G3”) and if folde does not exists need automatically created Thank you

[@imranwsayyed7357]

Mail be kyase send karrage. Excel se

[@thotanagamani9411]

Hi sir this is very helpful but i need pdf getting with password is better I need this one, is this possible

[@IrshadKhan-rk8jz]

please sir make video how link all sheet to summary sheet

[@Facts.9980]

Very informative thans. But i need ur help, mame sab asy e bana lia ha but ma sab employees ki pdf nai banana chahta just sab ka print chata hon on single click. Plz guide

[@user-vp3kn5eu3y]

can we use text & number mixture as unique eomployee code? how. please guide

[@bbEvz]

Hi. How do I fix an issue where the pdf conversion stops because there are empty cells in the list? Please help. I cannot delete the empty cells because it will be fill in in the future.

[@Rey-hv5gm]

Now how to automatically execute payment from such data

[@sainaths1369]

how to make file location dynamic, pls help

[@krishnajagadeesh6307]

How to all pdf in single pdf convert hi this Krishna I am your subscriber

[@rajachamundavanshi7296]

Run -time error '1004': Method 'Range'of object '_worksheet' failed Aa Raha he please solution

[@aliraza-tp2to]

What if we have different subjects for students mean to say that we are offering 10 subjects in total and students can choose 5 subjects than how we can make marksheet ..

[@muhammadmurtaza5847]

Sir is coad ko to wazahat kai sath send kar d plz

[@iqrachargulli1704]

السلام علیکم سر۔۔۔۔۔۔۔۔۔امید ہے آپ خیریت سے ہوں گے، سر اس فائلز کو مطلوبہ ای میل پر آتومیٹک ای میل کس طرح کریں گے اگر اس پر بھی ایک ویڈیو بنا دیں تو بڑی مہربانی ہوگی۔

[@EXCELDOERS]

As discussed on telephone, you may hire my service for custom development

[@samwilliam3121]

When executed the module, it is showing problem in the first line of code while debugging where as I have written the code exactly as you have written. Pl help to fix the issue. Showing Run Time Error 1004 and stating Method 'Range' of object'_Worksheet' failed. Pl help.

[@EXCELDOERS]

its working fine here.. check ur code again

[@sunlightcleaningcontractin5962]

@Kan Serano same problem here, I had been typed & set every thing correctly.

[@averaj]

how to include images for each empolyee

[@EXCELDOERS]

U can watch video on image on my channel

[@muhammadwaqas5986]

yeh code soft mein chahy ha mujhe plz share kr dain

[@EXCELDOERS]

email me

[@emerymukendi6909]

How to make it send via outlook?

[@rajkarnwal9908]

sir plz drop down the encoding

[@vaghanisatish9693]

Yha pe mereko ek sath sabhi slip generate nahi karani but Manually pdf slip generate karana hoto..??

[@EXCELDOERS]

u can do them.. i ll do explain in my future videos

[@afzalahmad6452]

Is it possible all the salary slip password protected by their employee number?

[@krishnajagadeesh6307]

How to dingle pdf convert like compine

[@EXCELDOERS]

Would u like to elaborate your question please?

[@krishnajagadeesh6307]

How to pdf content all pdf single files

[@dilipkumaryadav4617]

How to sent it to email sir , please upload video,

[@yhwh_renewalseries]

Hi, can you explain the "generating the pay slips" in ENGLISH

[@christiancanlubo8682]

I followed step by step, but I got an error of Runtime error 424 "Object required". Need help please

[@rajesingh158]

can i generate pay slip only with name

[@umair5bughio222]

Brother vlookup formula apply nai horha can you help?

[@smartway9997]

Can you provide the file sir?

[@aleksandr6698]

How to pdf content all pdf in single file

[@atikwarsi4819]

I am stuck on vlookup, I select employee id , range selected than 7:19 Second to 7.25 Second what u did I m not getting u said Second colume but uske baad I lost plz guide me I m keep getting error 😢😢

[@EXCELDOERS]

Vlookup(employeeid, range(muststart with employee id column till end), 2, 0)

[@atikwarsi4819]

Thanks Your Highness ,Yor are Great @@EXCELDOERS

[@firmaevents9594]

Is therea video in engkish

[@ajaykumarchejaraajaykumarc6857]

Please share this excel file

[@waelarja5321]

The file plz

[@EXCELDOERS]

Kindly email us the file first u made with video for review

[@mahantykalicharan1028]

How to all salary slips by email in one click

[@EXCELDOERS]

will make video soon

[@kiransuryawanshi3792]

Programing file send kro ....because of very fast ap bata raho ho...

[@touheedahmed4652]

iT SHOWS RUNTINE 1004 ERROR. Please tell me what to do??

[@discipletimz3106]

How do i get this in English

[@bhavneshparikh8283]

How to download sample file

[@IrshadKhan-rk8jz]

sale summary sheet link to all sheet

[@MrSanjay45]

Sheet2.Range("Employeeid").Value = Sheet1.Cells(n, "A")

[@MrSanjay45]

Problem

[@sarahmanb]

Visual Basic is a case sensitive programming language. You're writing Employeeid instead of EmployeeID and that might be a reason to your problem. Type properly and then try, will it helps.

[@ramsorosco]

do you have this video in English?

[@EXCELDOERS]

I ll make it soon.

[@sukhveer4716]

Runtime error 1004 aa rha hai How can I fix this

[@PiyushKumar-nl6mz]

automate Microsoft Excel Payroll generate employee pay slip Print all employee one click ka coding kaise likhe

[@harshrajmane8230]

Invalid procedure call or argument 🤷🏻‍♂️

[@VipinGupta-ru2cq]

Please send this code file

[@mdparvu]

Plz share code

[@muhammadaamir566]

code please...

[@afrinsir7479]

Please send this code

[@EXCELDOERS]

email me

[@afrinsir7479]

please me your email address

[@yoyosarkar471]

Command is not work

[@EXCELDOERS]

it do works.. please check ur code again.

[@yoyosarkar471]

@@EXCELDOERS I check many time plz give your number

[@shreeram3741]

Bhai, agr 1000 employees ki pay slip generate krke unki mail par keise bheje ek sath is par b bataiye

[@shreeram3741]

Bhai, agr 1000 employees ki pay slip generate krke unki mail par keise bheje ek sath is par b bataiye