Leave Management System in Excel
Вставка
- Опубліковано 27 сер 2024
- #LeaveTracker #ExcelTemplates
Hello Friends,
This is the enhanced version of the Annual Leave tracker. In this version, we have added a VBA user form to mark the leave for multiple dates in one go. We have also added the optional to mark the half-day Leave. You can use this template to track the leave for the different employees in monthly and annual views.
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download the practice file from the below link:
www.pk-anexcel...
Watch the video for first version of Annual Leaver Tracker
• Annual Leave Tracker w...
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcel...
Download the Calendar Control in VBA from below link
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...
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
Thanks for your valuable feedback
Very insightful and useful. Respect to the developer
Thanks for your valuable feedback🙏
Good task about employees leave management system of Excel.
Thank you sir for that.
Thanks for your valuable feedback
I love your video thanks you that you share your knowledge for all people in the world.
My pleasure!
Good update from the previous version !
Thanks🙏
Dear Respected, very very very informative for me & lot of Ms. Excel tools learn through your creativity.
It's my pleasure
You are creative and innovative
Thanks
amazing file vba leave management system I do like it so much PK!
Thanks for your valuable feedback🙏
Just stumbled upon your channel, PK. And I would like to say Thank You! This is extremely useful! Looking forward for more videos.
What a grt work u have been shared
.....well done
Most welcome
Gracias ING por enseñarnos ustedes es un gurú del excel saludos desde León Guanajuato 🇲🇽🤝
Gracias por sus valiosos comentarios
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
very useful thanks
You are welcome
Brilliant Job👏👏👏👏👏BRAVO
Thanks🙏
Thank you sir it is very useful video
Most welcome
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! 🎉
Awesome tutorials. I would love to see a kanban task manager in excel from you
will upload soon!!!
Excellent job done brother. HOW CAN WE CALCULATE EMPLOYEES' NUMBER OF LEAVES AVAILED BETWEEN HIS MONTH OF JOINING AND THE CURRENT MONTH?
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!
Thanks for your valuable feedback. I will try to add it in next version.
That's awesome video and tutorial as normal, teacher.
Thanks for your valuable feedback🙏
Thank you so much, Sir.
Most welcome
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?
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?
Great video PK
Thanks🙏
Awesome video PK! 👍
Thanks Satish
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
Thanks for the share.
Our pleasure!
Hey PK, this is so great, much thank you
Most welcome
Merci beaucoup
Très bienvenu
Excellent, PK. Kindly inform how to get it to omit Saturdays, Sundays and holidays if the leave taken extends over weekends
You can use networkdays while calculating the days. I will consider this in the next version.
@@PKAnExcelExpert yes i tweaked with it already;-)
@@excelworx8712 can you please share that file please????
Apologies, that was a project and the file belonged to a client. Work is done now and file returned
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
good one, one observation: instead reflecting employee ID in dropdown, you should be showing employee name. no one remember IDs but name
Nice Idea. Will consider in the next version.
Pls release as soon as. . I love to learn
@@chhoenlida you can interchange the data , in ID write name and vice versa , it works
Excellent Teacher!! Thanks so much! and.. for when a personal Budget with financial Dashboard?
Pleas
will upload soon
Thank you sir, i will like to see how you will create timer, clock, schedule process to run periodically, idle timer countdown in excel
Thanks for the idea! will upload soon
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.
I will try to incorporate this feature in next version.
Hi sir how to do the leave application form
Hi. Very good. Please make a tutorial on making a file manager in vba.
Thanks. Please watch the below video on file manager
ua-cam.com/video/1NQj17-3u10/v-deo.html
Yes, thank you. I have seen this video before. I mean how it was made.
It's nice...please release EOD status using Form....
will consider in next iteration.
@@PKAnExcelExpert Thanks for considering..Always nd more excited to your videos
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.
Nice suggestion! I will consider it in the next version.
@@PKAnExcelExpert thank you sir
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
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!!
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.
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
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 :)
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.
You are most welcome. I will try to incorporate it in next version.
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
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
Sir, if we keep employeename as combo and employeeid taken automatically, then what should i do. This is very useful
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
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
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
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
Good Suggestion. I will consider this in next iteration
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
I can't Download the Download the Calendar Control in VBA from below link
مرسی
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.
Wonderful video. Where do we download it
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.
Please can we get the template of this system?
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
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.
Can you set the leave tracker to automatically exclude weekends and public holidays?
I NEED HELP WERE TO ADD CALENDA
Please watch the below video:
ua-cam.com/video/Tg50qA6qtKE/v-deo.html
As Employee , I want to create my leave tracker , this is from employer end , i want to have personal leave tracker
Great suggestion! I will try to create a video on this topic.
@@PKAnExcelExpert Please share the link if video is possible on the topic
This is a big help ., Can you teach me how to code to download the leave summary
ore how to export to excel
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
@@PKAnExcelExpert thank you so much.
Hi PK, Can you make a tutorial on how to create a order tracking system. 🙏
Great suggestion! I will try to create a video on this topic.
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
will upload a video on this topic soon.
@@PKAnExcelExpert thanks PK :) you are amazing.
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.
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
will try to change it in next version
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.
How can we get this. I mean i need this excel file. Is there any way to download this thing.
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.
Hi PK in userform initialize i got error message saying that subscript out of range, please help me out
Please check the worksheet name. It should be same as available in VBA code
@@PKAnExcelExpert its the same
Is any possibility that we type employee I'd and start date and end date
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?
Use Intel formula
I have noticed one thing total days is calculating the entire days . Can we apply network days formula or logic.
Yes we can apply networkdays formula also
@@PKAnExcelExpert can you please make a video on this
Hi PK, is this possible to get a video on Google Sheet version of this?
Can we get the full coding for this video?
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
This is very good one.. Can you please share the link from where i can download this file?
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
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
If you are using Employee id as text, then you don't need to use "Clng" in the code.
PK: An Excel Expert ok sir let me try . Thank you
Sir can you pls show me DELETE Code in this form ?
Same problem
HI Priyendra, can you please create the tracker using employee name and it should calculate networking days
I will try to add this in next version
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?
in code you can delete Cln funcion and try this
hi, what is the meaning by (2, 0)?
Kindly look at the matter
how to use this system by more than one people
It will not work for multiple users. You can watch below video about multiple users:
ua-cam.com/video/PnZrH-fvMto/v-deo.html
Please create quarterly summary in leave tracker instead of monthly summary
will try to consider this in next version.
@@PKAnExcelExpert thank you, please try to upload quarterly as soon as can
kindly do the vehicle movement register application ( Vehicle Reported date , and time , Vehicle Number Supplier Name , Material Name , Qty , Status of the vehicle Unloading .
Will try to create a template on this.
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 ?
Yes, you can use
Sir How to Create "MARK LEAVE" Button In MARK LEAVE Sheet Please Explain Step by Step Please...!!!
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
@@PKAnExcelExpert Thank you 😊 Sir
@@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?
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
will consider in the next version
And you are not able to type ID number , you just scroll down up to 1000 to search the ID
I will try to incorporate this in next version
Hello Sir,
I am trying to reach you out and dropped an email also but no response, requesting you to respond at the earliest
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?
Hi
Solver password please
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?
This is great suggestions. I will try to consider it in next iteration.
Plz sir g apna number send kardo WhatsApp ki