Great work Mr Saha. I followed your help when I wrote to you for further help. At a senior age it was sweat and anxiety for me to do it and I finally accomplish completing my own ‘Fully automated ‘latecoming sheet’ in my case following your ver 3.0 video. You are a wonderful, patient and very competent expert in your field to help ordinary person like me. God Bless You👍🙏🏻.
So nice of you sir. Very nicely explained. It could clear my dought regarding creating attendance sheet for a particular year(say 2021). A lot of thanks. Thank you dada.
Thank you for the new tutorial, I want to keep the employee calendar view you had from your previous sheet, how do I update so that I can change the year as a drop down. Lastly is there a code I need to change the Holidays so it reflects throughout my workbook
Great job on this video! I followed your video and created a spreadsheet but I am having one issue. I use my reports monthly and want to track how many days my employees have remaining at the end of each month. When I clear the spreadsheet the formula reset to the amount of days they have at the beginning of the year. How do I keep track of the amount of days they use each month and have an ending balance that shows the amount that is used up to month I am working on? So when I get to the end of the year, say December, I can look at December's worksheet and see how many days they have remaining? Thank you.
When I put a p for any day in January it carries over to the next month. How do I keep this from carrying over to the next month? Thank you so much for your videos!
Thank you it was a great video - I have a question If I want new sheet to be copied in a new spreadsheet rather then different month sheet getting copied in different tabs of the same sheet (I think that makes the sheet very heavy) how can we do it ??
Hi, the file not be heavy and it will work fine if your machine updated. But if you want every month's sheet should be in different workbook then you can do it in two different ways: 1. Manually, right click on the sheet tab and click copy and move, then select tick the copy and select new workbook and click OK. 2. VBA code to automate.
You have done a very nice work on this. Worksheet. Please I will like a modification that will include marking attendance twice daily ie morning and afternoon. Also help on applying this to school register where total daily attendance is calculated, total weekly attendance is determined, weekly percentage is recorded as well as termly attendance. Thanks.
Am very happy to watch your videos sir, but i do have problem with making days, present or absent by making it absolute to be drag in order to save time. 🙏
Very Good tutorial and excellent explanation. In the tutorial, you've shown the attendance for 10 employees. It will be more helpful if you please give the details, that in future if any employee is added the formulas has to be taken care for those rows related to that employee. Also the employee column has to be align to alphabetical order.
Excellent video and very detailed. I made this automated attendance sheet for my needs. I wanted to count the attendances of employee on Fridays or Sundays in different columns. The only issue that i haven't solved is how to count all of the above through the year, on another sheet, since every time the data is cleared, for the next month, the results from "sum countifs" formula are zero. I must figured out how to keep data when months are changing. Thank you anyway.
Hi, I am glad to know that this tutorial helped you. And regarding your problem, I want to say something. After you have completed your attendance, you must click the copy button to copy the attendance to another sheet with the month name and then you clear the data of the attendance sheet. and start attendance for next month. And I will upload a video on another automated attendance sheet for the full one year. And on the next month, I will upload another attendance sheet in which you could make attendance for several years. I have already scheduled the upload date also.
@@SahaComputer Thank you! I'm looking forward to see the next video. One more issue that i have is that i want to protect the sheet but i get a Run-time error '1004' cause of the hidden columns VBA. Anyway this give me the stimulus to search and learn more about Excel. Thank you one more time!
In the code for hidding the column put extra code for unprotect and protect the worksheet. In 2nd line type ActiveSheet.Protect "unPassword" in 2nd last line type ActiveSheet.Protect "Password" Inside the qoute type your password
This is an excellent work indeed. I've been watching your work since beginning of 2019 only...so many improvements than the earliest one.. One thing is surprising that this excel sheet doesn't catch undo action! Any activity, may it be replacing or deleting, is permanent, no way back!! This made the use of this kind of difficult.. so whole data, if accidentally just deleted once, it's gone forever until starting from scratch.. Any solution?
Excellent, great work, Kudos, very practical, and very professional. !!! Namaste !! To make it adjustable to my company I would just import the employee id and name from a DB file ad copy down all the line formatting via VBA, the rest is done. !!! Great
hello, thank you, very nice video. I have done this but don't want to make a separate copy sheet for each month. instead, I want to have just one more sheet combining all the data of all the months from the attendance sheet. is it possible?
Thank you so much for making such a great video. I am trying to click the Project File download link above several times but keep getting the error saying "This site can’t be reached“. Are there other alternatives to download?
Hi, thanks for the updated sheet. I have changed the start date formula but kept end date (as per calendar month). Let's say our work day in February starts from 15th of the month but the subsequent months start from the 1st, the start date formula will start every month on the 15th. Any way to set start date dynamically for each monthly?
@@SahaComputer Thanks for the quick turnaround. I am using your attendance sheet for a factory workers class. Let's suppose our course starts from the 15th for one month only and then subsequent classes are being held on the 1st, I am unable to implement it through this method, since my month is not 30 days from start date but like a calendar month :) Any solution for that?
when we press button what is the vba code to send that sheet in pdf file in folder defined so it do automatically for multiple Year thanks very good informative video for us to learn though
hello thank you for the very clear and nice tutorial, i need your support as i am using this same template but not for attendance sheet but only for employee annual leave tracker, i just change some of the formulas which i prefer but only one issue is, how i will be able to shift to another month that it will be cleared and not take the same details as the previous ones.
Very encouraging for starter like me. Faced problems to get codes from the links in description. The sites which opened were not showing the links, pls guide
Hi, great tutorial but I have an issue with the check days macro where it works for all months apart from Feb and August where it fills in SAT in all cells etc, not sure how to fix this?
Thank You For the nice video i was trying the create sheet however it dosen't work with me, my month is in J2 and Year S2. also can we add a feature of calculating the overtime for each worker.
Thank you very much sir But I want the attendance sheet with Leaves and Absent .. Each employee has two leaves every month.. but if employee not took leaves, one leave was lapse and other leave will forward to next month. How can I do that.. if employee take more leaves than previous balance leaves, then balance leaves will be cut and other leaves as charged leaves.. how can I do
Hi, how would you deal with a situation where an employee has a leave, half day leave and we need to calculate total payable days. Like Payable days = Working days + Holiday + Saturday or sunday + Half day present - leave - Half day leave - Allowable leave, to calculate Total Payable days.
Hi, may I know how to make individual attendance? in this video we focus on a month, how about we want to focus about employee. their attendance throughout a year with their absent, public holiday and so on. can you help me?
Hello friend, thank you for these updates. Is there a shorter way or code to calculate the total workdays instead of using Day helper row and holidays helper row? Can't we introduce NETWORKDAYS days here (where the formula is modified for holidays too)?
Hi Sir, I appreciate your traning and guidance. I need one thing more how to calculate salary and overtime in same sheet. Please guide us. Thanking you.
Hi Saha, thank you for marvelous excel tutoring. I have asked this before and you already give the suggestion but I couldn't find a solution for it. So I now have 2 issues. 1. I give you a scenario. Say, I have staff who is planning to go on AL on 5th March 2021 but we are now at January 2021. Since it is in the same column, if I put AL on March 2021 cell AB6, it will appear AL on Jan 2021 column AB6. Similarly, if I put P on Jan 2021 on cell C6 until cell AG6, it will also appear in cell C6 until AG6 for months Feb, Mar, and so on. So how do I keep the data so that it will not goes missing? 2. How do I keep the total numbers of Workdays, AL, SL, and Absent from Jan till Dec? So that, if my staff taking SL 1 in Mar, 2 in Apr, 5 in July and 2 in Nov, I can see the total of 10 SL he is taking at the end of the year. Copy sheets and clear tables don't work for me as I want to see it in realtime rather than have to calculate manually. Something like accumulative figure. Thank you in advance.
1. For both problems you have to create all twelve months' attendance sheets in advance and put the value for AL on that month say March 21. To solve these problems are I will put two I am creating a one-year Attendance Sheet Tutorial and Multiple Year Attendance sheet tutorial You can see the example here: ruclips.net/video/QHr-4WsQo-E/видео.html I will upload within the first half of January 2021
Hi, how would you deal with a situation where an employee has a revolving day off per week. If week one is Monday, week two is Tuesday, week three is Wednesday so on and so forth. Also can you give a macro to keep a tally of leave as new sheets are saved automatically?
Hello, Great videos. I was wondering if there's a way to combine columns under a single day. For example, Day 01 will capture the following: Column a) Type of Leave taken (LS, LA, LH); Column b) Scheduled/Unscheduled Leave (SL or UL); column c) Present or Tardy; & Column d) Hrs. Again great videos and thanks for sharing.
Dear Sir, Few of my doubts from the previous version has been cleared. Really appreciate the work. I still have few doubts to be cleared, In the result section I want a separate column for Total Sundays and Total Holdiays separately. Is this possible if yes, can you please explain. Your effort will be much appreciated. Thanks
Yes, you can do that. Create a column for holidays and put the formula =COUNTIF($C$5:$AE$5,">0") Create a sunday column and put formula =COUNTIF($C$6:$AE$6,"Sun") and if you need sunday and saturday as weekend then put formula =COUNTIF($C$4:$AE$4,">5") This formulas are according to my worksheet.
@@SahaComputer Thank you sir, Appreciate your help. Will try and update you. Thanks again. But again if I use the above said formula than for February wont the the cell will count the blank cell ( Hidden) as holiday? Let me know sir. Thanx
I have checked everything its working fine with this formula =COUNTIF($C$5:$AG$5,">0") Remember that row 5 is the the helper row for holidays, if your problem still exist then your sheet's cell values may different from my sheet, in that case you can mail me your sheet.
Thanks so much for the wonderful Excel Tutorial on the Attendance Sheet or Register. But what about if the person has more names like up to 40 employees, how does one extend the Ranges to cover all the 40 employees? Thanks and remain blessed.
how to carry over the holidays on the years to come? only in 1 year does the holiday color formatting comes out. if you choose a different year, there's no color on holidays
Type holiday dates in holiday dates for all the years that you want to show, then it will get highlighted in the attendance sheet. Watch this video: ruclips.net/video/pDGmmIhqV2Y/видео.html Tutorial link given in description box of the video.
Hi, could you please advise me where do I find the VBA code for the 31 days code? I could not find it anywhere, those inside the description area you gave didn't give me any solution. I thank you in advance.
sir in your video you have properly entered dates in the format dd-mm-yy e.g. for chat puja you have entered 02-11-19 but when i am trying this in my excel it is getting converted into 11-02-19. how to solve this problem?? plz help
Hello, thank you very much for your video. It is very helpful for my work! Here are some questions: 1) is there a problem in VBA Code "CopyRename Worksheet"? It shows error when I click the "copy sheet"button. And the Copy Rename Worksheet.txt is blank after I download the VBA code link for "CopyRename Worksheet" 2) if I want to keep the privacy of the employees, and allow only particular employee to view his/her own information, is that possible?
@@SahaComputer I am facing the same issues. The notepad(VBA code for CopyRename Worksheet) in Google Drive is blank. And when I tried 'Copy Sheet' right after downloading your excel file without a single change(enabled Macro first), it is showing Error in code! Can you please check and let us know?
Hi, when I go to change the year now, it doesn't update the holidays to match colors in my future years. Everything else works perfectly. Any thoughts? Your videos are tremendous! (I rewatched the parts about the lists on the helper sheets, but I just can't get the holidays to update when I go beyond year 2020. Somehow my list is not dynamic I guess?)
Hi, Great video and thank you for content. I have one question.. Suppose this is for a sports team that are training twice or three times a day and attendance needs to be logged and counted. What would you suggest to do in this circumstance?
How to achieve the total of half day present instead of one full day, if half day leave was taken? And it's should reflect in leave column also... For example 0.5day, 1.5day, 2.5days... ect... Please help me to find the solution... Thanks ❤️
In the halfday column put the formula I used then divide it by 2, in the present coulum put the formula I used the add the formula that is used in half day column (used now).
To connect to Brad, my dynamic holiday list is working when new holiday dates are added, however, i noticed that where the month end with 30 days, there the column appears the same colour as the real holiday columns. My holidays appear purple. After making holidays dynamic, say in February, the two last columns after 29 also appears purple. Same for other ending 30. What is the problem here? My holiday list starts on 1/01/2020 and ends 31/12/2020.
The X is in place. In Feb there are 2 X's..so it's good. When i made holidays dynamic it worked but the only issue was i explained last time, the empty columns (in Feb and month with 30 days) show a holiday color when it should not. The problem can be solved if the columns are hidden but i don't want to hide any column.
@@SahaComputer Hello Brother, The problem was solved. I tried the formula today and it's working. No colors on blank columns are seen now. In fact, i have used your formulas to make a modified excel sheet of student attendance record for school. I can send a copy if you want. Added a few things to get more data. I wanted to ask one thing though: is there a possibility to automatically enter P once a few A's are manually inputted into a column?
Can you share code on how to search a record based on ID and specific date. For eg. employee with id e101 and I want to see his presence or absence till 15th of that month.
I would like to record the public holidays if the staff has not taken for example if the public holiday falls on the day he worked i want it to be accumalated how it can be done on your sheet
Lets say i want to report %absences quarterly or for whole year per employee on another sheet, can you show us how to pick up the information and present them on another sheet please?
I have already told in the 1st version of this file, how to use it. After creating the sheet completely as I have shown in the video, you have to click the copy sheet button, to create another sheet and there change the month and year and start your attendance. If you want it to be completely automated then watch this demo 1. One Year Attendance: ruclips.net/video/1tGSpi_4B_o/видео.html 2. Multiple Year Attendance: ruclips.net/video/pDGmmIhqV2Y/видео.html 3. Multiple Year Attendance with user id & Password: ruclips.net/video/6QvJ0t0L4_A/видео.html
Hello mate. You have done a great job with these sheets! I would like to ask you a couple of challenging specific questions. So my schedule is like "M M - O O - N N - O O - M M". It's 2 days of the morning shift(M) 2 days of day-off(O) and then 2 days of night shift(N). It continues like that. My first question is; if I put M or (however the month starting) I want formula that automatically fill rest of the month(or year if its possible) As you know because of coronavirus everybody's schedule were messed up. Is it possible to add feature that if I put certain number of dates one of the attendance's full work days, can any formula spread that certain number of dates to the row wit most logical way? For example; -name of the employee =X -days X' have to work=5 so when put "5" on work days column, I want it like: M M - O O- N O thanks in advance
Dear Sir, I have created an excel sheet for attendance as per your youtube video. I have 10 records with say ID as 10001, 11003, 12450, 11814, 11188 Name as ABC, XYZ, PQR, MNO, TUV and their full month attendance is calculated from 1st date of the month to the last date of the month. Like this I have created month wise sheets for 6 months from Jan to Jun. Now in another sheet I want a report as follows: If I enter ID of the person then it should show the average of the 6 months of no. of days present and no. of days absent If I enter ID and Date for a month (say 15th of the month), then it should display no. of days present and absent till 15th of the month. Hope my queries are clear. Anticipating earliest response.
My code is to copy the entire sheet, the process is same that we copy sheet normally, but as you said to copy only the the value and their formatting not the the formulas, in that case it possible but process will include create a new sheet and copy the data from attendance sheet to new sheet created. Yes it is possible, but it will take time to upload the video.
Hi Ivette, I am sharing my email address. Please contact me in my email and share all your requirement then we will have conversation. solutions4utb@gmail.com
ps. why not just combine the clear sheet macro with the copy sheet macro, less buttons that way. Logically you will only want to clear the entire sheet only when you are creating a new month anyway so this should streamline things.
I will upload its 4th version where, if you select a month from drop-down list, it will direct you to that month's sheet if it exist else it will create a new sheet for that month.
Im starting a project to automate duty rota, i tried to get this project files by filling the requied info and submitting my email since more than a week but no response.. Any one can please send to me?
Yes, you are correct but not completely because as you finish the attendance copy the sheet with copy sheet button and clear the master sheet and start new month's attendance. You can also go to our channel page and watch our current video those are more advanced.
Hy.im having problem with the monthly update.it cant produce a new sheet each month.itll update the previous month info into new month which is frustrating.
![YoungBoy Never Broke Again - Sneaking [Official Video]](http://i.ytimg.com/vi/1ILUps2zDFU/mqdefault.jpg)
Great work Mr Saha. I followed your help when I wrote to you for further help. At a senior age it was sweat and anxiety for me to do it and I finally accomplish completing my own ‘Fully automated ‘latecoming sheet’ in my case following your ver 3.0 video. You are a wonderful, patient and very competent expert in your field to help ordinary person like me. God Bless You👍🙏🏻.
Great work... Which part of the video shows if I change the month the inputs will not be the same as the previous month. Thank you.
So nice of you sir. Very nicely explained. It could clear my dought regarding creating attendance sheet for a particular year(say 2021). A lot of thanks. Thank you dada.
Check out this video your problem will be solved and you can also learn new features.
ruclips.net/video/NUK8PXLfggo/видео.html
Thank you very much. I want to make this automated attendance sheet for my new company , the Managing Director will be so happy. I owe you.
You are most welcome
Thank you for the new tutorial, I want to keep the employee calendar view you had from your previous sheet, how do I update so that I can change the year as a drop down. Lastly is there a code I need to change the Holidays so it reflects throughout my workbook
Watch this video carefully: ruclips.net/video/NUK8PXLfggo/видео.html
You will get the exact solution
Great job on this video! I followed your video and created a spreadsheet but I am having one issue. I use my reports monthly and want to track how many days my employees have remaining at the end of each month. When I clear the spreadsheet the formula reset to the amount of days they have at the beginning of the year. How do I keep track of the amount of days they use each month and have an ending balance that shows the amount that is used up to month I am working on? So when I get to the end of the year, say December, I can look at December's worksheet and see how many days they have remaining?
Thank you.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Thanks for the video, I watched your video because I work with Rotas. Very easy to follow :)
You are welcome!
When I put a p for any day in January it carries over to the next month. How do I keep this from carrying over to the next month? Thank you so much for your videos!
This is a single month attendance sheet you have watch other videos in our channel, Watch video 133 or 165 your problem will be solved.
Thank you it was a great video - I have a question If I want new sheet to be copied in a new spreadsheet rather then different month sheet getting copied in different tabs of the same sheet (I think that makes the sheet very heavy) how can we do it ??
Hi, the file not be heavy and it will work fine if your machine updated.
But if you want every month's sheet should be in different workbook then you can do it in two different ways:
1. Manually, right click on the sheet tab and click copy and move, then select tick the copy and select new workbook and click OK.
2. VBA code to automate.
You have done a very nice work on this. Worksheet. Please I will like a modification that will include marking attendance twice daily ie morning and afternoon. Also help on applying this to school register where total daily attendance is calculated, total weekly attendance is determined, weekly percentage is recorded as well as termly attendance. Thanks.
Please send your email address so I can send my request into it WD you suggested.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Am very happy to watch your videos sir, but i do have problem with making days, present or absent by making it absolute to be drag in order to save time.
🙏
It's not working for me because there's something you call it press f4 or copy f4 something like that but i fail to understand.
thanks
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
Very Good tutorial and excellent explanation.
In the tutorial, you've shown the attendance for 10 employees. It will be more helpful if you please give the details, that in future if any employee is added the formulas has to be taken care for those rows related to that employee.
Also the employee column has to be align to alphabetical order.
You have to drag the formula
Excellent video and very detailed. I made this automated attendance sheet for my needs. I wanted to count the attendances of employee on Fridays or Sundays in different columns. The only issue that i haven't solved is how to count all of the above through the year, on another sheet, since every time the data is cleared, for the next month, the results from "sum countifs" formula are zero. I must figured out how to keep data when months are changing. Thank you anyway.
Hi, I am glad to know that this tutorial helped you. And regarding your problem, I want to say something. After you have completed your attendance, you must click the copy button to copy the attendance to another sheet with the month name and then you clear the data of the attendance sheet. and start attendance for next month.
And I will upload a video on another automated attendance sheet for the full one year. And on the next month, I will upload another attendance sheet in which you could make attendance for several years. I have already scheduled the upload date also.
@@SahaComputer Thank you! I'm looking forward to see the next video. One more issue that i have is that i want to protect the sheet but i get a Run-time error '1004' cause of the hidden columns VBA. Anyway this give me the stimulus to search and learn more about Excel. Thank you one more time!
In the code for hidding the column put extra code for unprotect and protect the worksheet.
In 2nd line type ActiveSheet.Protect "unPassword"
in 2nd last line type ActiveSheet.Protect "Password"
Inside the qoute type your password
@@SahaComputer Thank you for the help. It works perfectly. I am so happy with the result. Have a nice day 🙂
Welcome
This is an excellent work indeed. I've been watching your work since beginning of 2019 only...so many improvements than the earliest one.. One thing is surprising that this excel sheet doesn't catch undo action! Any activity, may it be replacing or deleting, is permanent, no way back!! This made the use of this kind of difficult.. so whole data, if accidentally just deleted once, it's gone forever until starting from scratch.. Any solution?
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
Excellent, great work, Kudos, very practical, and very professional. !!! Namaste !!
To make it adjustable to my company I would just import the employee id and name from a DB file ad copy down all the line formatting via VBA, the rest is done. !!! Great
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi Sir, please advice how to highlight weekend days if shift changes in between the month.
Give me some more information.
hello, thank you, very nice video. I have done this but don't want to make a separate copy sheet for each month. instead, I want to have just one more sheet combining all the data of all the months from the attendance sheet. is it possible?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Thank you so much for making such a great video. I am trying to click the Project File download link above several times but keep getting the error saying "This site can’t be reached“. Are there other alternatives to download?
Fill out this form: forms.gle/j3kwdaMaLgxNWymb6
Hi, thanks for the updated sheet. I have changed the start date formula but kept end date (as per calendar month). Let's say our work day in February starts from 15th of the month but the subsequent months start from the 1st, the start date formula will start every month on the 15th. Any way to set start date dynamically for each monthly?
@@SahaComputer Thanks for the quick turnaround. I am using your attendance sheet for a factory workers class. Let's suppose our course starts from the 15th for one month only and then subsequent classes are being held on the 1st, I am unable to implement it through this method, since my month is not 30 days from start date but like a calendar month :) Any solution for that?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
when we press button what is the vba code to send that sheet in pdf file in folder defined so it do automatically for multiple Year
thanks
very good informative video for us to learn though
please watch the video, hope you can create it yourself
ruclips.net/video/75cywOLTMiA/видео.html
hello thank you for the very clear and nice tutorial, i need your support as i am using this same template but not for attendance sheet but only for employee annual leave tracker, i just change some of the formulas which i prefer but only one issue is, how i will be able to shift to another month that it will be cleared and not take the same details as the previous ones.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi sir, It's really a very good learning. Please make some more videos which is very interesting and always required and used everywhere. Thanks!!!
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Is there a way to add summary( year to date columns) all the attendance for whole year in addition to the month summary column on the right?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Very encouraging for starter like me.
Faced problems to get codes from the links in description. The sites which opened were not showing the links, pls guide
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
Great Work Mr Saha, thank you for sharing your knowledge with us.
Thanks and welcome
Hi, great tutorial but I have an issue with the check days macro where it works for all months apart from Feb and August where it fills in SAT in all cells etc, not sure how to fix this?
@@SahaComputer - Will do, do I use 'solutions4utb@gmail.com' ?
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
Thank You For the nice video i was trying the create sheet however it dosen't work with me, my month is in J2 and Year S2. also can we add a feature of calculating the overtime for each worker.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Thank you very much sir
But I want the attendance sheet with Leaves and Absent ..
Each employee has two leaves every month.. but if employee not took leaves, one leave was lapse and other leave will forward to next month. How can I do that.. if employee take more leaves than previous balance leaves, then balance leaves will be cut and other leaves as charged leaves.. how can I do
Watch this videos:
ruclips.net/video/kJFLnviz8jc/видео.html
ruclips.net/video/zH6zAGBdBQg/видео.html
ruclips.net/video/nVBWcC_cAF0/видео.html
ruclips.net/video/EBWM8GEK_d8/видео.html
Hi, how would you deal with a situation where an employee has a leave, half day leave and we need to calculate total payable days. Like Payable days = Working days + Holiday + Saturday or sunday + Half day present - leave - Half day leave - Allowable leave, to calculate Total Payable days.
Watch this video: ruclips.net/video/fw1iCPOXBUY/видео.html
You may also watch the complete series to learn more features.
Hi, may I know how to make individual attendance? in this video we focus on a month, how about we want to focus about employee. their attendance throughout a year with their absent, public holiday and so on. can you help me?
Please watch this demo video completely: ruclips.net/video/pDGmmIhqV2Y/видео.html
There is a sheet to get attendance details of a single employee.
Hello friend, thank you for these updates.
Is there a shorter way or code to calculate the total workdays instead of using Day helper row and holidays helper row?
Can't we introduce NETWORKDAYS days here (where the formula is modified for holidays too)?
You don't know, but networkdays.intl are specificatii pentru toate zilele saptamanii, poti alege oricare din zilele saptamanii....@@SahaComputer
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi Sir,
I appreciate your traning and guidance. I need one thing more how to calculate salary and overtime in same sheet. Please guide us.
Thanking you.
Hi Saha, thank you for marvelous excel tutoring. I have asked this before and you already give the suggestion but I couldn't find a solution for it. So I now have 2 issues.
1. I give you a scenario. Say, I have staff who is planning to go on AL on 5th March 2021 but we are now at January 2021. Since it is in the same column, if I put AL on March 2021 cell AB6, it will appear AL on Jan 2021 column AB6. Similarly, if I put P on Jan 2021 on cell C6 until cell AG6, it will also appear in cell C6 until AG6 for months Feb, Mar, and so on. So how do I keep the data so that it will not goes missing?
2. How do I keep the total numbers of Workdays, AL, SL, and Absent from Jan till Dec? So that, if my staff taking SL 1 in Mar, 2 in Apr, 5 in July and 2 in Nov, I can see the total of 10 SL he is taking at the end of the year.
Copy sheets and clear tables don't work for me as I want to see it in realtime rather than have to calculate manually. Something like accumulative figure.
Thank you in advance.
1. For both problems you have to create all twelve months' attendance sheets in advance and put the value for AL on that month say March 21. To solve these problems are I will put two I am creating a one-year Attendance Sheet Tutorial and Multiple Year Attendance sheet tutorial You can see the example here: ruclips.net/video/QHr-4WsQo-E/видео.html
I will upload within the first half of January 2021
@@SahaComputer Thank you very much and that was really amazing. I will wait for the update.
Hi, how would you deal with a situation where an employee has a revolving day off per week. If week one is Monday, week two is Tuesday, week three is Wednesday so on and so forth. Also can you give a macro to keep a tally of leave as new sheets are saved automatically?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hello, Great videos. I was wondering if there's a way to combine columns under a single day. For example, Day 01 will capture the following: Column a) Type of Leave taken (LS, LA, LH); Column b) Scheduled/Unscheduled Leave (SL or UL); column c) Present or Tardy; & Column d) Hrs.
Again great videos and thanks for sharing.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Great job Sir! There is a lot of things to learn in one sheet. It's really amazing!!
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Dear Sir,
Few of my doubts from the previous version has been cleared. Really appreciate the work. I still have few doubts to be cleared,
In the result section I want a separate column for Total Sundays and Total Holdiays separately. Is this possible if yes, can you please explain. Your effort will be much appreciated. Thanks
Yes, you can do that.
Create a column for holidays and put the formula
=COUNTIF($C$5:$AE$5,">0")
Create a sunday column and put formula
=COUNTIF($C$6:$AE$6,"Sun")
and if you need sunday and saturday as weekend then put formula
=COUNTIF($C$4:$AE$4,">5")
This formulas are according to my worksheet.
@@SahaComputer Thank you sir, Appreciate your help. Will try and update you. Thanks again.
But again if I use the above said formula than for February wont the the cell will count the blank cell ( Hidden) as holiday? Let me know sir. Thanx
I have checked everything its working fine with this formula
=COUNTIF($C$5:$AG$5,">0")
Remember that row 5 is the the helper row for holidays,
if your problem still exist then your sheet's cell values may different from my sheet, in that case you can mail me your sheet.
@@SahaComputer Thank You Sir! Will check and update you.
Thanks so much for the wonderful Excel Tutorial on the Attendance Sheet or Register. But what about if the person has more names like up to 40 employees, how does one extend the Ranges to cover all the 40 employees? Thanks and remain blessed.
@@SahaComputer Thanks for the kind reply. It really worked. I remain ever grateful.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
how to carry over the holidays on the years to come? only in 1 year does the holiday color formatting comes out. if you choose a different year, there's no color on holidays
Type holiday dates in holiday dates for all the years that you want to show, then it will get highlighted in the attendance sheet.
Watch this video: ruclips.net/video/pDGmmIhqV2Y/видео.html
Tutorial link given in description box of the video.
@@SahaComputer you're awesome! thank you!
Hi, could you please advise me where do I find the VBA code for the 31 days code? I could not find it anywhere, those inside the description area you gave didn't give me any solution. I thank you in advance.
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
sir in your video you have properly entered dates in the format dd-mm-yy e.g. for chat puja you have entered 02-11-19 but when i am trying this in my excel it is getting converted into 11-02-19. how to solve this problem?? plz help
Actually this is problem of system. You have to change the format from Control Panel-> Region and Language
Hello, thank you very much for your video. It is very helpful for my work! Here are some questions:
1) is there a problem in VBA Code "CopyRename Worksheet"? It shows error when I click the "copy sheet"button. And the Copy Rename Worksheet.txt is blank after I download the VBA code link for "CopyRename Worksheet"
2) if I want to keep the privacy of the employees, and allow only particular employee to view his/her own information, is that possible?
@@SahaComputer Hi Sir, thank you very much for your reply. I have sent the file to your gmail. please kindly check. Thanks!
@@SahaComputer I am facing the same issues. The notepad(VBA code for CopyRename Worksheet) in Google Drive is blank. And when I tried 'Copy Sheet' right after downloading your excel file without a single change(enabled Macro first), it is showing Error in code! Can you please check and let us know?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi, when I go to change the year now, it doesn't update the holidays to match colors in my future years. Everything else works perfectly. Any thoughts? Your videos are tremendous! (I rewatched the parts about the lists on the helper sheets, but I just can't get the holidays to update when I go beyond year 2020. Somehow my list is not dynamic I guess?)
I'm sure you have no holiday lists and dates added for the year selected.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi,
Great video and thank you for content. I have one question..
Suppose this is for a sports team that are training twice or three times a day and attendance needs to be logged and counted. What would you suggest to do in this circumstance?
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
thank you for addressing most of the concerns i had with the previous one!
Glad it was helpful!
Very nice and well explained Sir. Looking for more solid videos like this going forward !!
@@SahaComputer And I have some other questions as well. Can I put my requirements here or you want me to send out consolidated details over email ?
@@SahaComputer sure sir. I will let you know here
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
How to achieve the total of half day present instead of one full day, if half day leave was taken? And it's should reflect in leave column also... For example 0.5day, 1.5day, 2.5days... ect... Please help me to find the solution... Thanks ❤️
In the halfday column put the formula I used then divide it by 2, in the present coulum put the formula I used the add the formula that is used in half day column (used now).
@@SahaComputer yeah... Super... Thanks, have a great go...👍
Can you add OVERTIME if met total number of days?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hello and Great Video got to learn many sir small issue in "COPY BUTTON" wont copy
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
To connect to Brad, my dynamic holiday list is working when new holiday dates are added, however, i noticed that where the month end with 30 days, there the column appears the same colour as the real holiday columns. My holidays appear purple. After making holidays dynamic, say in February, the two last columns after 29 also appears purple. Same for other ending 30. What is the problem here? My holiday list starts on 1/01/2020 and ends 31/12/2020.
X is shown there, how to share?
The X is in place. In Feb there are 2 X's..so it's good. When i made holidays dynamic it worked but the only issue was i explained last time, the empty columns (in Feb and month with 30 days) show a holiday color when it should not. The problem can be solved if the columns are hidden but i don't want to hide any column.
@@SahaComputer
Hello Brother, The problem was solved. I tried the formula today and it's working. No colors on blank columns are seen now. In fact, i have used your formulas to make a modified excel sheet of student attendance record for school. I can send a copy if you want. Added a few things to get more data. I wanted to ask one thing though: is there a possibility to automatically enter P once a few A's are manually inputted into a column?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Great job i write you and i did the asking subjects on the link but I didn’t receive the excel on mail
Sent!
Thank you sir I received it
Can you share code on how to search a record based on ID and specific date. For eg. employee with id e101 and I want to see his presence or absence till 15th of that month.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Does the code generate itself or l have to do it myself
watch the video carefully and write down the code.
I would like to record the public holidays if the staff has not taken for example if the public holiday falls on the day he worked i want it to be accumalated how it can be done on your sheet
@@SahaComputer pls update me about this change
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
Lets say i want to report %absences quarterly or for whole year per employee on another sheet, can you show us how to pick up the information and present them on another sheet please?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
When filled Jan month attendance and changing to another month, the attendance entered Jan is reflecting in all other months.
I have already told in the 1st version of this file, how to use it. After creating the sheet completely as I have shown in the video, you have to click the copy sheet button, to create another sheet and there change the month and year and start your attendance.
If you want it to be completely automated then watch this demo
1. One Year Attendance: ruclips.net/video/1tGSpi_4B_o/видео.html
2. Multiple Year Attendance: ruclips.net/video/pDGmmIhqV2Y/видео.html
3. Multiple Year Attendance with user id & Password: ruclips.net/video/6QvJ0t0L4_A/видео.html
Hello mate. You have done a great job with these sheets!
I would like to ask you a couple of challenging specific questions.
So my schedule is like "M M - O O - N N - O O - M M". It's 2 days of the morning shift(M) 2 days of day-off(O) and then 2 days of night shift(N). It continues like that.
My first question is; if I put M or (however the month starting) I want formula that automatically fill rest of the month(or year if its possible)
As you know because of coronavirus everybody's schedule were messed up.
Is it possible to add feature that if I put certain number of dates one of the attendance's full work days, can any formula spread that certain number of dates to the row wit most logical way?
For example;
-name of the employee =X
-days X' have to work=5
so when put "5" on work days column, I want it like:
M M - O O- N O
thanks in advance
@@SahaComputer Thank you! If it's can be done I'm going to try it. I'll waiting for your videos
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Please tell me how to make the same sheet only Friday holiday
You have to change the formula in Data Validation and Conditional formatting.
This is great! Thank you very much!
You're very welcome!
Thank u very much ..
Can u please help me on copy sheet option as it is not working
How can I help you.
Can u please share the same sheet with time entry columns
Do you mean to say time entry column? If yes I surely upload a video on that.
@@SahaComputer
Yes please upload video
I will upload by this week.
can we make this attendance sheet in google sheet
Hello, I could find the code for the macro , I appreciate your help :)
You have to purchase this file to get the code. link given in the description box. In case doesnot work contact me solutions4utb@gmail.com
Hello, experiencing error when i enter data validation - it's giving error - A name range you specified cannot be found .. what went wrong ?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi, video 20:58, i couldnt find the code as per video. please help me.
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
Please Create HR Related worksheets, Thanks for the video
Okay sure
hello sir sorry to say that I am see your 2019 sheet & try for 2020 now I am facing some problem!?!
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
مرسی
You are welcome.
Dear Sir,
I have created an excel sheet for attendance as per your youtube video.
I have 10 records with say
ID as 10001, 11003, 12450, 11814, 11188
Name as ABC, XYZ, PQR, MNO, TUV
and their full month attendance is calculated from 1st date of the month to the last date of the month. Like this I have created month wise sheets for 6 months from Jan to Jun.
Now in another sheet I want a report as follows:
If I enter ID of the person then it should show the average of the 6 months of no. of days present and no. of days absent
If I enter ID and Date for a month (say 15th of the month), then it should display no. of days present and absent till 15th of the month.
Hope my queries are clear.
Anticipating earliest response.
@@SahaComputer please let me know once video is out. Pls drop link so i will check
Project file link is not available
Fill out the form with correct email address, project file wil be emailed to you.
Hello sir
I tried to apply this formula =datevalue(g2&b2&l2) but i didnt work
The result is always #value!
Because in my sheet g2 is the start date
B2 is the month
I2 is the year ..that's why i wrote it this way
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
How do I copy only Value and Format into another sheet? Your example is copying everything including formulas :-)
My code is to copy the entire sheet, the process is same that we copy sheet normally, but as you said to copy only the the value and their formatting not the the formulas, in that case it possible but process will include create a new sheet and copy the data from attendance sheet to new sheet created. Yes it is possible, but it will take time to upload the video.
Thanks Again sir.. this is awesome :)
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi, am unable to get sheet name automatic, when I copy the sheet
@@SahaComputer let me check....Thank you
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hi, is there any way you can send me a copy of the Mirco codes for the 31 days?
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Sir
I entered the formala for holidays in attadence sheet but it,s shows like this #name
What went wrong
I have checked all but i did not get
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
I seen video on Bulk Absent present by click button. Please send link for same
ruclips.net/video/pDGmmIhqV2Y/видео.html
@@SahaComputer I want video in which you describe script for bulk Present by click button "P"
ruclips.net/video/a4HpBggm18w/видео.html
Hi there I am unable to find the macro's can you help please?
Fill out the form in description box, you will get the total file.
from where to copy or download code?
How much to create this for me to use for work,n,,
Hi Ivette, I am sharing my email address. Please contact me in my email and share all your requirement then we will have conversation.
solutions4utb@gmail.com
@@SahaComputer okay will do now
OK
how can i found t he VBA codes?
Download link is in the description box.
ps. why not just combine the clear sheet macro with the copy sheet macro, less buttons that way. Logically you will only want to clear the entire sheet only when you are creating a new month anyway so this should streamline things.
I will upload its 4th version where, if you select a month from drop-down list, it will direct you to that month's sheet if it exist else it will create a new sheet for that month.
Please Could you send me a copy of this workshop..
Please see the description box below the video, the link of the file is already given there.
THANKS
PLS SEND ME THE LINK OF THAT FILE
@@SahaComputer Hi Sir. Could you please send me that sheet as well ? My email id : rohanc298@gmail.com.
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
सर आप ये विडीयो हिन्दी में बना सकते है क्या सर प्लीज बताने का श्रम करे।
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Im starting a project to automate duty rota, i tried to get this project files by filling the requied info and submitting my email since more than a week but no response.. Any one can please send to me?
I was in a problem so I cannot send you. I will send you today.
@@SahaComputer thank you waiting for your reply
@@SahaComputer please send it on s.mujtaba@live.com if you have time
file sent.
@@SahaComputer thank you very much sir 💐
Sir.. can u give me ur contact detials. I want to know about how to make the attendance sheet to hotal field.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Sir please give you content number for code making. For parivesh sheet, then I will use this sheet
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Second and fourth saturday holiday set karna ho to
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Hello,
Why put download files on such a site, which only annoys you.
There are enough honorable file sharing sites, or put the file in dropbox ....
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Getting Error while copying Attendance sheet.
Sub Copyrenameworksheet()
Dim ws As Worksheet
Set wh = Worksheets("Attendance")
I have to see the code that you have written and I have to also check the cell reference are correct or not. Is it possible?
Please send me the V3.0 file and VBA Codes
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: ruclips.net/video/QHr-4WsQo-E/видео.html
The code generation is my problem
watch the video carefully and write down the code.
Pls.make vide in hindi with payroll
My hindi is not good but I will try.
But this act only for one month
Yes, you are correct but not completely because as you finish the attendance copy the sheet with copy sheet button and clear the master sheet and start new month's attendance.
You can also go to our channel page and watch our current video those are more advanced.
Send file pls
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Pls send me the file
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html
Sir, I have sent you a email
Hy.im having problem with the monthly update.it cant produce a new sheet each month.itll update the previous month info into new month which is frustrating.
You can check out this video your all problem will be solved.
ruclips.net/video/NUK8PXLfggo/видео.html