Browse categories
Explore
Fiverr Pro
English
$
USD
I will create an automated leave tracker with formulas, dashboard and custom rules
Excel VBA Automation Specialist, HR, Payroll, Attendance
I am an Excel and VBA automation specialist with experience creating complete HR and business tools. I build custom automated Excel systems such as:
Attendance trackers
Leave management systems
Payro...
About this Gig
I will create a fully automated Leave Tracker in Excel that makes it easy to manage employee SL/CL/EL, custom leave types, monthly totals, and dashboards. The tracker will be clean, user-friendly, and designed to match your company's leave policies.
You will get automated formulas, color-coded status, carry-forward logic, and a summary dashboard (Standard & Premium). The Premium version includes VBA automation, leave validation, alerts, protected formulas, and advanced customization based on your rules.
I have 6+ years of experience in HR and Workforce Management and specialize in Excel automation for attendance, leave, payroll, and employee data. If you need specific featuresmulti-shift rules, manager approval, year-end reports, or custom leave policiesI can build them exactly as required.
Share your format or requirements, and I will deliver a smooth, accurate, and professional leave management tool.
Programming language:
Other
Technology:
Excel
•
Google Sheets
Analysis Type:
Quantitative Analysis
•
Descriptive Analysis
Expertise:
Business Insights
•
Trends
Tools:
Other
FAQ
FAQ 1 Can you customize the leave types?
Yes, SL/CL/EL or any custom leave categories can be added.
FAQ 2 Can you add carry forward or yearly limits?
Yes, I can automate carry-forward rules and monthly/yearly limits.
FAQ 3 Will the tracker work in Google Sheets?
Formulas work in Sheets; VBA works only in Excel.
FAQ 4 Can you add a dashboard?
Yes, dashboards are included in Standard and Premium packages.
FAQ 5 Can you automate the sheet using VBA?
Yes, VBA automation is included in the Premium package.
