Automated Annual Leave Tracker version 1.0

Поділитися
Вставка
  • Опубліковано 11 гру 2024

КОМЕНТАРІ • 57

  • @ezkul95828
    @ezkul95828 3 роки тому

    First of all, thanks for your great works. I have my own tracker. When I see yours, I have more idea to modify mine.
    What I see is that some of the holidays are good for your country only i believe, and the holiday calendar is for the year of 2019. If we can change it to work for any year this would be prefect.

  • @jawadkhan4786
    @jawadkhan4786 5 років тому +3

    Your videos are great. Learning a lot from you. Start a complete series on School management system. I know you can do it. Keep it up bro..

    • @thedatalabs
      @thedatalabs  5 років тому

      Thanks for your appreciation!

  • @margaretlopez2195
    @margaretlopez2195 4 роки тому +1

    Wonderful...thank you for taking the time to show this. Much appreciated.

  • @davidamoakoagyemang3365
    @davidamoakoagyemang3365 2 роки тому +1

    This is great. Thank you. But unfortunately, i don't see any support sheet in my excel file. What could be the reason?

    • @thedatalabs
      @thedatalabs  2 роки тому

      Thanks for your feedback! You can download it from the link available in the description box. Download is available at the end of the page. Thanks!

  • @happylife2407
    @happylife2407 2 роки тому

    Thank you so much. This tutorial video is very great! I need to creat a annual leave application form for manager's approval, then collect data to an excel record, and finally goes to calendar for marking who's absences. How should it work? Thanks

  • @nikkin9283
    @nikkin9283 5 років тому +1

    Please share link to download this macro , it would be of great help

    • @thedatalabs
      @thedatalabs  5 років тому

      You can find the link in description box. Thanks!

  • @pratheekprakash9259
    @pratheekprakash9259 5 років тому +1

    First off all, Great application,
    I wanted to inform you that there is a bug in the code, let me explain this with an example.
    suppose I am applying for a Leave.
    first I click on Plan and select the employee name- employee 1, leave type as - CL/HL/SL not AL ( "because the code is working fine with AL, but not with CL,HL,SL" ), start date as - dec 10th 2019 and end date as - 9th jan 2020, after clicking on submit, the data is successfully stored in the database, but when we click on summary, the same date is also been added for the month of feb and march. for all the three i.e (SL,CL,HL) this is happening but not for AL. could you please rectify the issue !!? awaiting your reply !

    • @thedatalabs
      @thedatalabs  5 років тому +1

      Thanks for your appreciation and feedback! Please send the mail. Will rectify the code and upload it again.

  • @habibtitu
    @habibtitu 4 роки тому +1

    Hello brother it was really great database. I just love it. Thanks for sharing. I have some following issues 1. For example, if I have more than 500 employees how do we entry employee name ? 2. Can we use employee ID to avoid errors with same named 2 employees? 3. If I want to put data entry past leave for example today is 9th and I want put data who has already enjoyed leave 2nd to 7th than how do I give entry (because we collect paper leave form). 4 If I want see employee leave status in dashboard is it possible? Sorry I have asked a lots of questions. I am really facing lots problems at the moment we can’t buy software. It will be great pleasure to get kind reply from you. Thank once again.

  • @milospavlovic5160
    @milospavlovic5160 5 років тому +1

    Great video and very helpful. Is there any way that you can maybe show how to add one more employee from VB. I have no idea what i'm doing :)

    • @thedatalabs
      @thedatalabs  5 років тому

      Thanks for your appreciation! Please send your requirements on our email id. Will try to make changes whenever you will get time. Thanks

  • @rolandnormiljacques1678
    @rolandnormiljacques1678 5 років тому +2

    Very Nice! Great video,
    Thanks

  • @borahan5882
    @borahan5882 5 років тому +1

    Hi thanks for your great tools. However, when i open file, it doesn't show the worksheet and I can't change the emp name or leave type

    • @thedatalabs
      @thedatalabs  5 років тому

      Thanks for your appreciation! Please check it again as this tool is working perfectly my system.

    • @borahan5882
      @borahan5882 5 років тому

      TheDataLabs yeah i unhide it already, but the problem is that i add emp name but it doesn’t save in rawsummary and summary

    • @borahan5882
      @borahan5882 5 років тому

      Can u tell me how to add new name and save to all worksheet when i add in plan form?

  • @sanjeevchowdhry
    @sanjeevchowdhry 2 роки тому +1

    Hello. It is a great application. But some how after downloading the sheet, I cannot view the sheet tabs. Please advise

  • @pawanmore948
    @pawanmore948 4 роки тому

    I am not able to see support sheet in latest tool. May i know how i will get that sheet. Needs to Update Holiday and Name of employee ?

  • @kranthikirans3847
    @kranthikirans3847 4 роки тому

    Hi, thanks for the video. But I could not find the link to download the excel file. Please share the link to download

    • @thedatalabs
      @thedatalabs  4 роки тому +1

      You can find two different pages in website. One is dedicated to description and another is to download. Thanks!

    • @kranthikirans3847
      @kranthikirans3847 4 роки тому +1

      @@thedatalabs Thank you very much

  • @kothawzinn
    @kothawzinn 4 роки тому +1

    Could you provide passwords to unprotect workbook and VBA?

    • @amrichtetteh
      @amrichtetteh 4 роки тому

      Did you get the password? Share with me if you got it.

  • @mfneyaz
    @mfneyaz 5 років тому +1

    we are learning !

  • @jamesmwanza4289
    @jamesmwanza4289 2 роки тому

    Great work, This will definitely help me. Kindly could you share the code in the project. It's somehow locked

  • @Steelersrock3443
    @Steelersrock3443 Місяць тому

    The download link on the website is not working. Is there a way to download besides that, i've tried on multiple different browsers and everything is pulling up a website and not downloading anything.

    • @thedatalabs
      @thedatalabs  23 дні тому

      Thanks for sharing this issue! We will check and fix the error.

  • @oneskilltutorials964
    @oneskilltutorials964 5 років тому +1

    Thank you so much

  • @ocean7447
    @ocean7447 5 років тому

    cannot find the support sheet and database

    • @thedatalabs
      @thedatalabs  5 років тому

      Please check the below link to download the file.
      thedatalabs.org/annual-leave-tracker/download-leave-tracker/

  • @nprakash5753
    @nprakash5753 5 років тому +1

    How do I download the file!!!

    • @thedatalabs
      @thedatalabs  5 років тому

      You can find the link in description box. Thanks!

  • @mangjas
    @mangjas 5 місяців тому

    I downloaded the latest version and I believe there is an issue as it not deducting weekly off. How to fix this issue

    • @thedatalabs
      @thedatalabs  4 місяці тому

      Will check and fix the issue. Thanks!

  • @mdismailhossain5438
    @mdismailhossain5438 3 роки тому

    full version hogi download ka lia

  • @sanjuktabhagat4107
    @sanjuktabhagat4107 4 роки тому

    Hello sir, This is a nice video, but I can't create the tracker. If you step by step make this every sheet then I will easily make this leave the tracker.

  • @Patelbhaves231
    @Patelbhaves231 5 років тому +1

    Dear Sir, I watch your video and it is amazing useful tool for small company. I am developing a other tool for my office. which is relate to Task organisation. detail of this i will email you.

    • @thedatalabs
      @thedatalabs  5 років тому

      Thanks for your appreciation! I will Keep uploading Excel based automated tools. Please keep supporting on UA-cam. Thanks! 😊

  • @roshanfernandes4383
    @roshanfernandes4383 2 роки тому

    There is no Download Link...🙄

  • @emilythewonderdog
    @emilythewonderdog 4 роки тому

    Hi Sir,
    Can I discuss with you.

    • @thedatalabs
      @thedatalabs  4 роки тому

      Hi Imran, please send your queries on our email id. Thanks!

  • @abdulrasid1572
    @abdulrasid1572 5 років тому

    hello sir.. this video is very good.. Can i get it the file..

    • @thedatalabs
      @thedatalabs  5 років тому

      Thanks for appreciation!
      Yes, link of the file has been provided in description box. Please download it. Thanks!

  • @amrichtetteh
    @amrichtetteh 4 роки тому +1

    Can you provide the password to the sheet and the VBA?

  • @josemanalo9916
    @josemanalo9916 4 роки тому

    Please how to download the system

    • @thedatalabs
      @thedatalabs  4 роки тому

      Please download it from the link available in the description box. Thanks!

  • @mantzboy
    @mantzboy 4 роки тому

    wow that is great! Could you please make organizational chart using vba in excel. Thanks

  • @hrd8569
    @hrd8569 3 роки тому

    how to add employees

  • @sasmitasamuel6490
    @sasmitasamuel6490 3 роки тому +1

    Can you kindly give the password for vba codes so that I can learn

  • @sanjaysrivastava1100
    @sanjaysrivastava1100 4 роки тому

    Can't hear anything even at full volume please amp up the volume

  • @ravishankar-sg9ry
    @ravishankar-sg9ry 5 місяців тому

    Plzz in hindi

  • @khalidiqbalsiddiqui46
    @khalidiqbalsiddiqui46 3 роки тому

    Very unuseful information