Leave Management System in Excel

[@miguelprietosanchez5883]

My Friend congratulation from Venezuela you are better thank for all you teaching. I like very much the infogrphic the better . I have learn much thankyou

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sudinroy7979]

Good task about employees leave management system of Excel. Thank you sir for that.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@zsolttolgyesi7910]

Very insightful and useful. Respect to the developer

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@asimsiddiq475]

Dear Respected, very very very informative for me & lot of Ms. Excel tools learn through your creativity.

[@PKAnExcelExpert]

It's my pleasure

[@dawnjarder]

Just stumbled upon your channel, PK. And I would like to say Thank You! This is extremely useful! Looking forward for more videos.

[@nnbona]

amazing file vba leave management system I do like it so much PK!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@kunleangsortcoursemsoffice1197]

I love your video thanks you that you share your knowledge for all people in the world.

[@PKAnExcelExpert]

My pleasure!

[@djioman3243]

best channel. I have Q.. In Marke Leave can we choose the name instead of a number, this means the name will show as a list, and then when we click on the name his employee number will show

[@TheTramos00]

Good update from the previous version !

[@PKAnExcelExpert]

Thanks🙏

[@Bretonne951]

Brilliant Job👏👏👏👏👏BRAVO

[@PKAnExcelExpert]

Thanks🙏

[@peteyboi1122]

Hello great video, sorry if I’ve completely missed it on the video, but how does the dates get added into the calendar? I can see how it counts and display amount of days taken but not how it adds it to the calendar

[@James-fk3si]

This is great. Can you please advise how to not include weekends and public holidays? As when it does it adds these as days off?

[@shahanbabarofficial]

Excellent job done brother. HOW CAN WE CALCULATE EMPLOYEES' NUMBER OF LEAVES AVAILED BETWEEN HIS MONTH OF JOINING AND THE CURRENT MONTH?

[@mohamedel-hanfy9140]

You are creative and innovative

[@PKAnExcelExpert]

Thanks

[@aarizmirza9905]

What a grt work u have been shared .....well done

[@PKAnExcelExpert]

Most welcome

[@iam_miraabalos]

Thank you for this template. I learned a lot. I just want to check if we can add a function to limit the number of employees who apply leave in day. Also, it would be good to skip the weekends and public holidays on the day count. Hoping to get a response! Thanks again!

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will try to add it in next version.

[@grijalvaescobedo158]

Gracias ING por enseñarnos ustedes es un gurú del excel saludos desde León Guanajuato 🇲🇽🤝

[@PKAnExcelExpert]

Gracias por sus valiosos comentarios

[@thomaspapamargaritis5945]

Awesome tutorials. I would love to see a kanban task manager in excel from you

[@PKAnExcelExpert]

will upload soon!!!

[@FingersD27]

Hi PK I'm new to VBA and don't know much so I loved this and was trying to use and adapt it to use myself, but running into a problem. I wanted to do a reverse of the user form where when someone opens the form the first combo box is the one they can get a drop down of their name and then the second one automatically fills their ID Number. I've tried everything to reverse the code but lost because I want the exact same thing only instead of the user picking the ID first I wanted them to pick their name as they may not know their ID Number. Any hep appreciated!! Thanks Mark

[@excelworx8712]

Excellent, PK. Kindly inform how to get it to omit Saturdays, Sundays and holidays if the leave taken extends over weekends

[@PKAnExcelExpert]

You can use networkdays while calculating the days. I will consider this in the next version.

[@excelworx8712]

@@PKAnExcelExpert yes i tweaked with it already;-)

[@ashutoshwalimbe6774]

@@excelworx8712 can you please share that file please????

[@excelworx8712]

Apologies, that was a project and the file belonged to a client. Work is done now and file returned

[@info2satish]

Awesome video PK! 👍

[@PKAnExcelExpert]

Thanks Satish

[@suhani11official33]

Thanks for the awesome tracker. Need one suggestion can we create a birthday email sender using VBA . But macro should pick the Date automatically and send the birthday email.

[@PKAnExcelExpert]

I will try to incorporate this feature in next version.

[@hafizhussienelneelhassan5941]

That's awesome video and tutorial as normal, teacher.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@BrijeshKumar-ol3yx]

Thank you sir it is very useful video

[@PKAnExcelExpert]

Most welcome

[@ICTNuggets]

Great video PK

[@PKAnExcelExpert]

Thanks🙏

[@mohammedansar5280]

very useful thanks

[@PKAnExcelExpert]

You are welcome

[@albanoteles4924]

Excellent Teacher!! Thanks so much! and.. for when a personal Budget with financial Dashboard?

[@ahmedmokhtar190]

Pleas

[@PKAnExcelExpert]

will upload soon

[@battadfamily2204]

How about if i have a excel and leave tracker already and I wanted to get a summary of leave of emp including the date and type of leave in one excel how can i do that

[@J_Bant]

hi excelent video. can you create template for only annual leave planner using the same data entry? my goal is to see if the employee leave will clash between another employee, also it should have the option if the employee wants to split his leave throughout the year for ex. he wants to leave on may for 10 days and june for 5 days and in November for 9 days. It will be a huge help and much appreciated if it comes with a Gant chart to see the overlapping of leaves. thanks in advance

[@sanjeevfernandes8280]

This is amazing!!! one question, how to get total days consumed by an employee. For ex. In my company, employees are entitled for 30 days leave in an year. So if someone took more than the entitled days, how to find it? if someone took 40 days this year, for next year his entitlement should be only 20 days. How to make such leave tracker?

[@kayyumforu]

Hello Mr. PK, after clicking the submit button it doesn't enter the required entries into the "Mark Leave" sheet. Macro runs and the "Done" dialog box appears but nothing gets entered in the sheet. And no error as well.

[@ratovononyjamesharisson183]

Hey PK, this is so great, much thank you

[@PKAnExcelExpert]

Most welcome

[@MohAboAbdo]

Thank you so much, Sir.

[@PKAnExcelExpert]

Most welcome

[@benjokeks6765]

Thanks very informative. But I'm having an issue my excel file become so slow. If I'm using VBA and lookup formula. Please help guys

[@renatadino8384]

Hi PK, I'm getting addictive to your videos :) one question, let's say I made a mistake submitting the leaving, how can I delete it? if I tried I'll delete all the formulas from that Row. thank you

[@kayyumforu]

Can you show the code for the download button or to export the history from list box to new excel file?

[@Alim-sr3iv]

Good work.But how will you differentiate saturday and Sunday. I think it will mark as leave even if u put sunday's date as well. Ideally it shouldn't allow to mark as leave Saturday and Sunday.

[@PKAnExcelExpert]

Nice suggestion! I will consider it in the next version.

[@Alim-sr3iv]

@@PKAnExcelExpert thank you sir

[@danburns10]

Can someone explain how he got the calendar imagine to fit the small image box? and where/how did he create the calendar view when choosing the dates for leave? Thank you :)

[@maheshth9701]

Hi Thank you so much, I was able to create leave tracker, However I have request how to apply Maximum Leaves each emp based on the leave type in Marke leave sheet Appreciate your quick help

[@imrandreepaul897]

Sir, First of all a big THANKS for the leave management, its a wonderful job and has ease my job... thanks again. Just one thing i would like if you could write a filter in the tracker so that we can track the leave through the leave type also. Thanks you in advance. Awaiting for a response please.

[@PKAnExcelExpert]

You are most welcome. I will try to incorporate it in next version.

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

[@mohdalyahri]

Why use the method of repeating vacation days in the "Mark Leave" sheet? Adding a "Helper" column with the end date might help, reducing the number of input lines. You can also include a "Print Detailed Report" for an employee or print a "Detailed Report during a specific period" thanks any way! 🎉

[@atiqurrahman1962]

This is an extremely excellent job you have done here. Sir, I need to submit the leaves in columns by start date (E3) & end date (F3) in my leave tracker. Could you please help me by editing the VBA codes again? Thank you very much for what you have done until now.

[@nyelesi1]

Can you set the leave tracker to automatically exclude weekends and public holidays?

[@rezaulislambhuiyan8510]

Sir, if we keep employeename as combo and employeeid taken automatically, then what should i do. This is very useful

[@PKAnExcelExpert]

need to change the code accordingly. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com and try to change the code accordingly

[@lalitaarumuegam5396]

Hi sir how to do the leave application form

[@CarMaestre]

Hi Pk this video is very helpful to me. I learned a lot from this. But my concern how can i mark the leave if the personnel is in a 24hr operation? Like we have 3shifts operation 8am-2pm day shift 2pm-10pm night shift 10pm-8am midnight shift

[@gauravdalvi3582]

Hi PK- will you able to make allocation tracker to team members where team members will get allocation daily and they just need to put feilds which are necessary using database

[@PKAnExcelExpert]

will upload a video on this topic soon.

[@gauravdalvi3582]

@@PKAnExcelExpert thanks PK :) you are amazing.

[@wilfriedyao7197]

Thank you sir, i will like to see how you will create timer, clock, schedule process to run periodically, idle timer countdown in excel

[@PKAnExcelExpert]

Thanks for the idea! will upload soon

[@rameshbhilai]

In employee I'd drop down menu we have to choose I'd if employee are more than it is time taking for data entry can u get that we can type IDs

[@PKAnExcelExpert]

will try to change it in next version

[@DJ-ri4bq]

Wonderful video. Where do we download it

[@PKAnExcelExpert]

In order to access the download link, kindly refer to the description box accompanying the video presentation. Alternatively, please feel free to visit our website at www.PK-AnExcelExpert.com for further information and resources.

[@user-ri7xy7gh2m]

Hi. Very good. Please make a tutorial on making a file manager in vba.

[@PKAnExcelExpert]

Thanks. Please watch the below video on file manager kzbin.info/www/bejne/Z3-0m2RtYpioZ5I

[@user-ri7xy7gh2m]

Yes, thank you. I have seen this video before. I mean how it was made.

[@b1utt]

Please can we get the template of this system?

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@tarifm.8881]

Hi PK, is this possible to get a video on Google Sheet version of this?

[@ramgella518]

This is a big help ., Can you teach me how to code to download the leave summary

[@ramgella518]

ore how to export to excel

[@PKAnExcelExpert]

You can download this template and you see all the VBA code in the file. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@ramgella518]

@@PKAnExcelExpert thank you so much.

[@Abdulbaqi8]

Thank you But how to add new employee? When i add name in monthly summary ,then moving to "mark leave" for test , it's stuck when choosing that name!!

[@RaizooTv]

I can't Download the Download the Calendar Control in VBA from below link

[@TPGamer_1]

PK Bhai, VBA Is currently disabled for me, so i how calculate the start date and end date, plz advise a formula for it ? Greatly appreciate your video, learned a lot.

[@abdoulayediop108]

Merci beaucoup

[@PKAnExcelExpert]

Très bienvenu

[@rameshbhilai]

Is any possibility that we type employee I'd and start date and end date

[@suhani11official33]

I have noticed one thing total days is calculating the entire days . Can we apply network days formula or logic.

[@PKAnExcelExpert]

Yes we can apply networkdays formula also

[@suhani11official33]

@@PKAnExcelExpert can you please make a video on this

[@karthickravichandran1355]

It's nice...please release EOD status using Form....

[@PKAnExcelExpert]

will consider in next iteration.

[@karthickravichandran1355]

@@PKAnExcelExpert Thanks for considering..Always nd more excited to your videos

[@imrandreepaul897]

I get a Run Time error '13' Type mismatch: in column Employee code as i have to insert an alpha numeric code. How to resolve it

[@vinayakdubey]

How can we get this. I mean i need this excel file. Is there any way to download this thing.

[@PKAnExcelExpert]

In order to access the download link, kindly refer to the description box accompanying the video presentation. Alternatively, please feel free to visit our website at www.PK-AnExcelExpert.com for further information and resources.

[@suhani11official33]

HI Priyendra, can you please create the tracker using employee name and it should calculate networking days

[@PKAnExcelExpert]

I will try to add this in next version

[@StrengthWithSingh]

As Employee , I want to create my leave tracker , this is from employer end , i want to have personal leave tracker

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@StrengthWithSingh]

@@PKAnExcelExpert Please share the link if video is possible on the topic

[@lanlanrockable]

hi, what is the meaning by (2, 0)?

[@nokelalyadav13190]

Sir ye sheet mil payega kya

[@borkaranish6034]

Can we get the full coding for this video?

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@salonitanwani1158]

This is very good one.. Can you please share the link from where i can download this file?

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@HOME-REPAIR95]

Hello I need my list box in VBA to display the columns from right to left, but the number of cells in Excel is large, and when I run VBA, my list box displays from left to right, and I want to see the first columns. I have to scroll from the right side, what should I do to fix this problem, please help me. Also, I aligned the list box to the right in the form settings, but it didn't help.

[@giefanytubo3951]

Hi PK in userform initialize i got error message saying that subscript out of range, please help me out

[@PKAnExcelExpert]

Please check the worksheet name. It should be same as available in VBA code

[@giefanytubo3951]

@@PKAnExcelExpert its the same

[@evonnelee6120]

Hi PK, Can you make a tutorial on how to create a order tracking system. 🙏

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@chhoenlida]

The EMP ID are number . If EMP ID use number with symbol This code is error (ex: 01-001) can you tell me how to do it pls ? Thx q

[@PKAnExcelExpert]

If you are using Employee id as text, then you don't need to use "Clng" in the code.

[@chhoenlida]

PK: An Excel Expert ok sir let me try . Thank you

[@chhoenlida]

Sir can you pls show me DELETE Code in this form ?

[@latkhorboxmovei-33]

Same problem

[@sksamma4834]

Hi.. I hope someone reply how to fix this.. So instead of employee ID if i have their first letter of their first and last name in their employee ID field.. it says "run time error 13" i think it only wants to have numbers in that column not letters. is there a way to change this?

[@ashutoshwalimbe6774]

in code you can delete Cln funcion and try this

[@an00pSharma]

good one, one observation: instead reflecting employee ID in dropdown, you should be showing employee name. no one remember IDs but name

[@PKAnExcelExpert]

Nice Idea. Will consider in the next version.

[@chhoenlida]

Pls release as soon as. . I love to learn

[@ashutoshwalimbe6774]

@@chhoenlida you can interchange the data , in ID write name and vice versa , it works

[@maambofloyd]

I NEED HELP WERE TO ADD CALENDA

[@PKAnExcelExpert]

Please watch the below video: kzbin.info/www/bejne/ipiYYaR3a9angac

[@akfirooz]

Great as always PK! Can we add the leave entitlements and allow employees to apply for the amount they are entitled to? Any extra taken shall be deducted from their salaries. For example, ABC is entitled to 10 Annual Leave, she already availed 5 and the remaining balance is 5 days. But she comes with another request of 6 days, we can grant her 5 Annual Leave and 1-day unpaid leave. Also, when employees cannot take their leaves during the year, we should transfer the available balance or at least a portion of the available balance to the next year automatically.

[@vinayakdubey]

Sir please please reply. I publish this tracker for my organisation. And i have more than 3000 employees. Now its too deficult to find Employee id eith scroll bar. What my organization want is that we can search employees id by typing in full. Instead of searching by scrolling. Please help me. My job is in danger. How to

[@powerofpivotart8998]

Always nice to learn!!! one request - if we would like mark leaves, starting from Friday till Monday, it captures 4 days however SAT & SUN are Weekly off so technically should add 2 days leaves, is there any way to consider Weekly offs to exclude while marking leaves? Also, could we incorporate list of Public Holidays so that they also populate automatically for given month as applicable?

[@9035451964bose]

Use Intel formula

[@alializadeh8195]

مرسی

[@sirmagger]

Good System, I found it be very slow and resource hungry though, Also i think the employee ID and employee name should be reversed, it is easy to remember employee's name than ID

[@PKAnExcelExpert]

Good Suggestion. I will consider this in next iteration

[@mohebulahbarakzai2525]

there is some issues to be mentioned to be rectified, 1. you cant enter the employee number, instead you just select from drop-down list 2. when you enter the emp number it will give you his leave balance and history that how much and which leave he used

[@sudinroy7979]

Sir, here you use MS-visual book for application for some specific tasks. But my question is that can I use MS-visual studio 2019 version instead of MS-visual book for application for same purpose ?

[@PKAnExcelExpert]

Yes, you can use

[@mohibullahbarakzai6666]

it is great but, there is no way to understand the employee's available leaves, while you enter the employee ID and then select the type of leave, it will show how much leave he has available.

[@pinaldon]

Sir How to Create "MARK LEAVE" Button In MARK LEAVE Sheet Please Explain Step by Step Please...!!!

[@PKAnExcelExpert]

You can insert the ActiveX control command button from Developer tab >> Insert. You can see the code on given in the template file. Template file download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@pinaldon]

@@PKAnExcelExpert Thank you 😊 Sir

[@pinaldon]

@@PKAnExcelExpert Sir I Still Confuse As per you said i saw again your Leave Tracker Video but in Mark Leave Sheet How To Create The Code For("MARK LEAVE" BUTTON) its not Mention in your Video .as per Your Guidance i will create the Button From Developer >Insert>Active X Control. But Which Coding Apply to Operate The Mark Leave Button?, SO When I Click The("MARK LEAVE Button") & Then Direct Open the Leave Tracker Format. So Please Explain Me How is this Working?

[@NeelamSingh-pg1fs]

how to use this system by more than one people

[@PKAnExcelExpert]

It will not work for multiple users. You can watch below video about multiple users: kzbin.info/www/bejne/hp-9o3tjm9uAqtE

[@kicksrini8239]

kindly do the vehicle movement register application ( Vehicle Reported date , and time , Vehicle Number Supplier Name , Material Name , Qty , Status of the vehicle Unloading .

[@PKAnExcelExpert]

Will try to create a template on this.

[@sravs1057]

Please create quarterly summary in leave tracker instead of monthly summary

[@PKAnExcelExpert]

will try to consider this in next version.

[@sravs1057]

@@PKAnExcelExpert thank you, please try to upload quarterly as soon as can

[@rameshbhilai]

Kindly look at the matter

[@punithh406]

Hello Sir, I am trying to reach you out and dropped an email also but no response, requesting you to respond at the earliest

[@SanviPatil2019]

Sir isme agar last year Closing leave add hote aur running year plus hote to current year closing leave samajh aate.. eg. LAST YEAR CLOSING LEAVE CL ( CASUAL LEAVE )=0 ML ( MEDICAL LEAVE) = 55 EL( Earned leave ) = 43 WP = 0 and current year leave CL ( CASUAL LEAVE )=12 ML ( MEDICAL LEAVE) = 10 EL( Earned leave ) = 10 WP = 0 ab dono Ki sum CL = 12 EL = 65 ML = 53 WP = 0 ab current year me employee ne leave liye to leave minus ho jana.. agar eg. CL = 09 EL = 16 ML = 23 WP =0 REMAINING LEAVE AS BELOW CL ( CASUAL LEAVE )= 03 ML ( MEDICAL LEAVE) = 49 EL( Earned leave ) = 30 WP = 0 aisa Report isme aana chyahiye

[@PKAnExcelExpert]

will consider in the next version

[@tijuleema3252]

Hi

[@mohibullahbarakzai6666]

And you are not able to type ID number , you just scroll down up to 1000 to search the ID

[@PKAnExcelExpert]

I will try to incorporate this in next version

[@tijuleema3252]

Solver password please

[@szenyee]

Hi sir, this is very useless video and template. I just wonder if you advise how can we enhance further this template to keep track on further such as the Yearly Entitlement, Balance, Leave Adjustment?

[@SanviPatil2019]

sir mujhe lagta hai.ki agar isme pivot table ki madat li jaye to vba + pivot se aur powerful leave record software ban sakta hai.. pivot se kya hai ki.. employee wise.. branch wise... hight leave wise.. without pay wise..year wise report hum show kara sakte hai....to isme yeh sub karo.. aur bahot important baat ki hum year wise data save kar sake.. agar last year all employee ka leave data dekhna ho to woh bhi aa jaye.. mere kehna hai ki har year closing ho gai to leave data save ho jaye..jo bhi sal ya month ka data dekhna ho to dekhne aa jaye?

[@PKAnExcelExpert]

This is great suggestions. I will try to consider it in next iteration.

[@computertips9974]

Plz sir g apna number send kardo WhatsApp ki