VBA Code to Automate Salary Slips

  Рет қаралды 47,281

12th Analytics

12th Analytics

Күн бұрын

In this video, 12th Analytics will show you how to prepare salary slips using VBA Macro in Excel and get print out of all the slips on a single click.
Excel file is available at
drive.google.com/open?id=0B8Q...

Пікірлер: 53
@luisenc789
@luisenc789 3 жыл бұрын
Hi Abdul Nisar, I like the way you taught the vba portion. Very clear way to teach someone how to program. GREAT WORK!!!
@Abdulnisar1
@Abdulnisar1 7 жыл бұрын
Thank your brother, very interesting, especially the excel format you attached. Now can see the coding very clear.
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Thank you Abdul Nisar :-)
@aquibjaved6209
@aquibjaved6209 3 жыл бұрын
This was really great.
@ariskavanessen7303
@ariskavanessen7303 7 жыл бұрын
Thank you for your great video.
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Ariska Thank you for the feedback :-)
@DavidAntwiBoasiako
@DavidAntwiBoasiako 3 жыл бұрын
Thank you very much.
@Rajan-kk8nl
@Rajan-kk8nl 3 жыл бұрын
Very nice wonderfull. Thank you very much.
@deepakkhanduri2714
@deepakkhanduri2714 6 жыл бұрын
Thanks brother
@PeggywongPeggy
@PeggywongPeggy 4 жыл бұрын
in spore workers they have OT claims split into 2 kind one is 1.5 hours and 2.0 hours if they come back to work during holiday is consider 2.0 hours how am i going to write the code
@karuppusamyn515
@karuppusamyn515 4 жыл бұрын
Sir, already i have created same in xls. I have generate pay slip keep the manual lookup value. Each sheet two pay slips fixed in my format. Now, how i can generate pay slip only selected employees ID numbers like 1000 to 1050 in pdf format. Kindly advise in another one video. I hope you. Thank, Regards, Karuppusamy N
@karuppusamyn515
@karuppusamyn515 3 жыл бұрын
Thank you sir... I have a salary slip in xls vlookup function. I have generated slip number wise copy paste option used. Now how I can save pdf in single button using macros
@rakeshkumar-me2pv
@rakeshkumar-me2pv 7 жыл бұрын
thank you very much very helpful
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Rakesh Thanks for your feedback :-)
@prasannareddy2603
@prasannareddy2603 6 жыл бұрын
How u use vlookup function in dis
@busikukapikanya7706
@busikukapikanya7706 4 жыл бұрын
now how will it be stored for future use the payroll also how to send emails via gmail
@rinah3088
@rinah3088 6 жыл бұрын
Thanks for sharing this amazing video. However noticed on the VBA formula ....... Do While a
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Rina. Thanks for your feedback. Its a good idea, I will update my video :-)
@youtuberravi14
@youtuberravi14 6 жыл бұрын
using a
@SureshBabu-kk6tn
@SureshBabu-kk6tn 4 жыл бұрын
Can u help me how by entering employee code his details r changing???
@punyashlokahilyadeviholkar5019
@punyashlokahilyadeviholkar5019 4 жыл бұрын
Nice explanation Sir ! I have used it and generated my pay slips but I need your help to regarding same.Please Help me.
@punyashlokahilyadeviholkar5019
@punyashlokahilyadeviholkar5019 4 жыл бұрын
As per above pdf printout are generating with same name. How to change file name ? Please help me sir.
@rkexcel2686
@rkexcel2686 5 жыл бұрын
next month ke kiye kya karana hoga kya baya data banana padega kuch aisa kijiye mant select karane par usi month ka data salect ho jaye
@JK-hm3lf
@JK-hm3lf 5 жыл бұрын
I want to do opposite. My task is to copy salary details of each employee and generate report containing the details of pays and allowances allocated for all employees in that month. The problem is, allowances and deductions are not in consective cells. Please share another video on generating report with details of salaries of all empolyees.
@ayantabujara1719
@ayantabujara1719 7 жыл бұрын
Thanks for sharing this video. What if I want to print Emp1001-1005 only? How will I do it?
@SubramanyanKP
@SubramanyanKP 7 жыл бұрын
just change the line in the macro where it says "Do While a
@ayantabujara1719
@ayantabujara1719 7 жыл бұрын
okey I'll try, thanks.
@PeggywongPeggy
@PeggywongPeggy 4 жыл бұрын
may I have the code
@AbdullaKhizamworld
@AbdullaKhizamworld 5 жыл бұрын
Can Anyone explain me save Xls and send Xls File not PDF?. This is Awesome post Btw
@soohailakhtar
@soohailakhtar 5 жыл бұрын
Dear I am using this code to print Employees pay slips, Its really help me and save my time,... Please can you help me,,, I am using Letter size page to print pay slips I have over 800 slips , so its using lot of pages. Is there any way during printing 3 or 4 slips are printing on 1 page i.e Letter Size page, I am using printer Epson 2190,,, Thanks Sohail
@rithveek
@rithveek 7 жыл бұрын
Kindly try to make a complete payroll solution by making salary sheet in which we have to fill just no. of working days n salary for each month should automatically gets generated and also the payslip is generated by linking salary sheet of each month to it
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Rithveek. Thanks for sharing the idea. Actually I was busy with some assignments. I will create such video in future.
@atulsahu2326
@atulsahu2326 7 жыл бұрын
could you please explain how to generate salary slips in ms access
@atulsahu2326
@atulsahu2326 7 жыл бұрын
in pdf format
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Atul. I will share a video soon on MS Access :-)
@peekaypk
@peekaypk 6 жыл бұрын
How can we code to create single file PDF of file containing year Salary Slip in for 1 EMP Pls help if possible
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Pradeep! So, basically you want one PDF file for all Salary Slips??
@peekaypk
@peekaypk 6 жыл бұрын
Yes
@globalfoundry2912
@globalfoundry2912 7 жыл бұрын
is their any way to whatsapp the salary slip ??? Via whatsapp desktop ???
@SubramanyanKP
@SubramanyanKP 7 жыл бұрын
A Salary Slip is a confedential information and not worth sharing through whatsapp and email ids like google and yahoo..
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Global Foundry. You can use gmail, yahoo etc but if you have desktop version of WhatsApp you can send it.
@raghuram45
@raghuram45 6 жыл бұрын
Hi If we use alphabets with Employee Id for Ex: ABC001 OR ADCD1000. how to enter the value instead of 1001. please help
@youtuberravi14
@youtuberravi14 6 жыл бұрын
you can use serial no.
@raghuram45
@raghuram45 6 жыл бұрын
Raviish14 please help me with correct coding I already mailed you from raghuram49@gmail.com
@youtuberravi14
@youtuberravi14 6 жыл бұрын
Download file and change employee ID and it will work with same coding
@mukundnirmal7667
@mukundnirmal7667 5 жыл бұрын
Sir aap ki avaj slow hai please video teg avag ki video bheje please sir jaror bheg dena sir
@juskonig
@juskonig 7 жыл бұрын
The sound on this video is urribble :(
@12thAnalytics
@12thAnalytics 6 жыл бұрын
Hi Justin. Thanks for the feedback. I know the poor quality of voice. Actually I created these videos as a fun using a third class handfree. In future, It will be awesome :-)
Automate printing Payslips and Salary slips
32:24
Ajay Anand
Рет қаралды 12 М.
Jumping off balcony pulls her tooth! 🫣🦷
01:00
Justin Flom
Рет қаралды 19 МЛН
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 34 МЛН
Женская драка в Кызылорде
00:53
AIRAN
Рет қаралды 497 М.
How to Create Automated Pay Slip in Excel and Save PDF Copy
17:38
Excel 10 tutorial
Рет қаралды 46 М.
Link every worksheet to a Master Sheet in Excel (10 Levels)
1:13:07
How to Create a Data Entry Form in Excel
34:30
Excel Macro Mastery
Рет қаралды 266 М.
Automate payslip in PDF on one click in Excel
29:45
B for Basic
Рет қаралды 9 М.
Send WhatsApp and Email without VBA
18:35
PK: An Excel Expert
Рет қаралды 154 М.
Jumping off balcony pulls her tooth! 🫣🦷
01:00
Justin Flom
Рет қаралды 19 МЛН