#82-How to Make Automated Attendance Sheet in Excel - Step by Step Tutorial
Жүктеу.....
Пікірлер: 1 600
@creativetvliberia15743 жыл бұрын
I am so grateful to God Almighty and to the producer of this video, this lesson had push me a steps further while on the path of Success. Like I always maintain, Success is not a destination but rather a PATH. Again I say big thank you yaaah...
@SahaComputer
3 жыл бұрын
You are very welcome
@PrashantMishra-kl8se
2 жыл бұрын
Please share a video in which can calculate half day as .5
@SahaComputer
2 жыл бұрын
If you want to get the total of total present including halfday, then create another column and type =Total Present+(Total Halfday /2)
@alokghosh93114 жыл бұрын
The year should also have a drop-down list to choose the year and the attendance sheet changes according to the selected year and month. Overall great VDO. Teaching is good, felt that you are in front of me...
@alokghosh9311
4 жыл бұрын
@@SahaComputer One more thing, in the Sunday and Holiday columns should be displayed as "S" and "HL" in every cell automatically, then this will be more attractive...
@mrlodi17
4 жыл бұрын
Appreciate Video! Excuse me for chiming in, I am interested in your opinion. Have you heard the talk about - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a great one of a kind product for getting 7000 plus project management and business templates without the normal expense. Ive heard some amazing things about it and my buddy at very last got astronomical success with it.
Thanks for reminding me my memories (back 7years from now). When I was working as Admin and I was very familiar with this attendance sheet. Thanks a lot.
@SahaComputer
3 жыл бұрын
Its my pleasure!! Thanks for your comment.
@ThatTechDude132 жыл бұрын
Thanks for The Video Sir, if anyone feels like giving up on this ...it actually works
@SahaComputer
2 жыл бұрын
Thanks for your comment.
@baihaas4 жыл бұрын
You r genuis my brother .. big effort maked .. i ask about attendance .. when i put ( P,A,H) in any months . I find it the same schedule i want each month to be kept separately ..
For our office we have sat and sun as weekoff. How can i insert that in formula for both days. As in video it shows only sun. Highly Appreciate your video which will be helpful for everyone. Hatsoff
Amazing.... immersed in it... realised that 30 min just flew...cos each and every second was informative..simply awesome
@SahaComputer
3 жыл бұрын
Glad you liked it!
@kb7417
3 жыл бұрын
Dear Sir, I have a question if we have to find number of holidays and sundays and listing them in a column ( For example we have 5 sundays and 2 holidays, then Total off day will be 7. But how do we separate sundays and holidays in a column using the above attendance sheet ) ... I did try but I am stuck here. Hope you will find me a solutions. Thanks
@lhadsaligss72152 жыл бұрын
Thank you! Great idea
@SahaComputer
2 жыл бұрын
Thanks for your comment.
@baihaas4 жыл бұрын
Bravo,, THIS IS AWESOME,, Great effort thannnnnnnnnnnnnnnnnnnnk u ,, u r Geniusssssssssssssssssssssssssssssssssssssssssssssssss
Do you have a sample code for time in, time out for employee/teachers using RFID card (tapping) badly needed pls. thanks in advance
@SahaComputer
3 жыл бұрын
Watch this video kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
@mymemories38302 жыл бұрын
Very helpful - thanks
@SahaComputer
2 жыл бұрын
You're welcome!
@mrhalimhashim233011 ай бұрын
tqvm .... i m follow this step by step till success to complete it.
@SahaComputer
11 ай бұрын
Glad to hear that.
@mahamanodesigns63503 жыл бұрын
How to find out,when an employee worked for more than 24 hours continuously ...I.e yesterday' day and night and again today's day...because an employee should not continue his duty more than 12 hrs ....so please clarify
@SahaComputer
3 жыл бұрын
This attendance sheet is not time based so it is clearly understood that the employee works within office hours.
@thestranger3772
Жыл бұрын
This is not time tracker this is attendance tracker
@fforrester4 жыл бұрын
Great video and easy to follow! How do I change the year from 2019 to 2020?
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
@dhrubabehera97132 жыл бұрын
Thanks you bhaiya mein to sab sikh gaya
@SahaComputer
2 жыл бұрын
Great!! agar tum isse better attendance sheet banana chahate ho to niche diye link click karo. kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html kzread.info/dash/bejne/onh7z8-CmNS8Yrw.html kzread.info/dash/bejne/aIWqrJKtYK-aj6Q.html
@immanuelraj30373 жыл бұрын
Thank you so much, I have successfully completed.
@SahaComputer
3 жыл бұрын
Excellent!
@eizinmon88703 жыл бұрын
Thanks a lot Sir!
@SahaComputer
3 жыл бұрын
So nice of you
@vinceaverythirdpontioso17863 жыл бұрын
I love this!!! It's been nine months since pandemic and I have hard time in manual entry for attendance... Browsing your vids and see what helpful tips I can find... Looking for time in and out in Excel.....
@SahaComputer
3 жыл бұрын
Glad you like them! Watch this update video: kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
@m.n.9532 жыл бұрын
thank you sir you are champion you explain it step by step very clearly to understand.may god bless you
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
@talksofsarika43493 жыл бұрын
Thanks a lot for making this video. It has helped me to make an attendance sheet in the Excel.
@SahaComputer
3 жыл бұрын
You are most welcome
@bijokuruvilla3 жыл бұрын
Thanks for the Tutorial. Appreciating your great mind
@SahaComputer
3 жыл бұрын
Thanks for your nice comment.
@misslati18072 жыл бұрын
Thank you so very much !!! very well explained I managed to do my own, thank you once again
@SahaComputer
2 жыл бұрын
Glad it helped!
@navyasharma88323 жыл бұрын
Really very helpful for my mother as she is making attendence chart for her school ! ❤️
@SahaComputer
3 жыл бұрын
Great, It helped. Thanks for the comment.
@thiyakup73333 жыл бұрын
Very nice teaching step by step, great and very helpful
@SahaComputer
3 жыл бұрын
Glad it was helpful!
@DoorHangerH14 жыл бұрын
Thank you for creating this easy to follow explanation. I also appreciate that it doesn't rely on outside "plug ins" that my jobs network doesn't allow.
You should check the latest video in my channel, I have uploaded complete automation on attendance where you can take attendance, manage leaves & payroll every thing is there.
@amitpathak52942 жыл бұрын
It is very helpful and very informative video thank you very much
@SahaComputer
2 жыл бұрын
You are most welcome
@RTimo11 ай бұрын
Thank you for making it in English. This sooo helpful
@SahaComputer
11 ай бұрын
You're welcome 😊
@Dietitionist.official3 жыл бұрын
you're an excel pro!!
@SahaComputer
3 жыл бұрын
Hi, Thanks for your appreciation. I request you to visit our channel, we have videos on different types of attendance sheet tutorials.
@josephalles83503 жыл бұрын
Thank you, for teaching me steps-by-steps.. for a Slow Learner like me this became so easy for me.. Thank you!
@SahaComputer
3 жыл бұрын
Glad it was helpful!
@kellyoku4 жыл бұрын
Masterclass...............Thank you.
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
@manohartimothy58253 жыл бұрын
You have explained it so well , there is no question to be asked...thanks so much and see you with new program-mes....Manohar Timothy
You're welcome! You can watch other attendance sheet in our channel. They are even more better.
@naturecreation72392 жыл бұрын
Its a great very useful work done by you.can i get this sheet for myself .
@SahaComputer
2 жыл бұрын
Link in the description box.
@oxygen_deprived10902 жыл бұрын
This taught me a lot, very easy to follow. Thank you so much!
@SahaComputer
2 жыл бұрын
Glad it was helpful!
@zhanyzhaks76112 жыл бұрын
This Tutorial is amazing. I wished the year should also have a drop-down list so that the attendance sheet changes according to the selected year and month. If possible please send it to us. thanks
@SahaComputer
2 жыл бұрын
You can watch this video, there are several updates: kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
@blackdude214 жыл бұрын
Very good class sir
@SahaComputer
3 жыл бұрын
You can check out this video your all problem will be solved. kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
@ramajayam.e23483 жыл бұрын
Thanks a lot sir
@SahaComputer
3 жыл бұрын
You are most Welcome.
@harshapadmanabhaiah36132 жыл бұрын
Great love it
@SahaComputer
2 жыл бұрын
Thanks
@syakirahzulkifli6423 жыл бұрын
Nice, thank you👍
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
@arvindparmar90413 жыл бұрын
Very important sheet for beginner's
@SahaComputer
3 жыл бұрын
Thanks for your comment.
@sonalidevadnye82042 жыл бұрын
VERY NICE
@SahaComputer
2 жыл бұрын
Thanks
@nephtalicastellan43117 ай бұрын
That was a great tutorial. How do I change the year?
@SahaComputer
7 ай бұрын
Please check this video: kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html Please subscribe our channel.
@ManojKumar-qz3hk4 жыл бұрын
Very useful, Thank you very much.
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
@princesstorres29544 жыл бұрын
Bravo! Very clear, was able to create my own, thank you so much :)
Hi thanks for this awesome vid.. Here in philippines we have many kinds of holiday.. trying to set regular holidays, special nonworking holidays and special working holidays.. how do i set this in the same timesheet? with conditional formatting as well.. i'm kind of stuck. trying to copy what you do.
@SahaComputer
2 жыл бұрын
You can type your weekends in Weekend list and Holidays in the holiday list in the setting sheet. If you have different holiday list then you cannot do that in this sheet. But still you can do this by keeping all holiday dates in single list.
@hddodo90902 жыл бұрын
thanks a lot that exactly what i need i made my form with some additional cell that show boys absents and attendance also girls for each day in the month
@SahaComputer
2 жыл бұрын
Great!
@esubalewgebrie93924 жыл бұрын
Really Good job!!! God bless you forever . It is very important for our Country( Ethiopia) factory .
Hi, thanks for sharing this video, which formula other than data value I can use to select the year of my preference and not the computer system year? I appreciate your help.
@SahaComputer
Жыл бұрын
See video 96.
@amanarora17403 жыл бұрын
THANX YOU VERY MUCH
@SahaComputer
3 жыл бұрын
You're welcome!
@katturantk64782 жыл бұрын
Sir ours is multi branch multi city.how we can make attendance by branchwise and at the same time consolidated and sync with all branches
@benjaminosei18423 жыл бұрын
Hello. Thank you very much for tutorial. It’s very helpful. I want to create an attendance for only Sunday’s with no holidays. Please can you assist me with some steps on how to do that? Thank you.
@SahaComputer
3 жыл бұрын
You can use this attendance sheet, just exclude the VBA.
@successbyyou4 жыл бұрын
Thanks for the wonderful information shared through this video.
Really helpful. Thank you soo much. I need to know one more thing. Can any one help me out. If we have one more employee added after doing all this process. We need to do the same process again or is there any shortcut.
@SahaComputer
2 жыл бұрын
You can add as much employee as you want but in this tutorial we have taken the range upto 10 employees , you can take it for 100 employees.
@naturecreativity2838
2 жыл бұрын
I have also taken the range upto 15. But i want to increase upto 90. My question is. I need to do the process from the start or is there any shortcut, i want to add employees to same sheet and wouldn't do the whole process again.
@SahaComputer
2 жыл бұрын
Just drag down the formula with fill handle upto row 90. Check new attendance sheet: kzread.info/dash/bejne/onh7z8-CmNS8Yrw.html
@smarkliang14 жыл бұрын
Super good teacher. Thanks for explaining in details. Appreciate it. You have kind heart. Thank you so much sir.
@SahaComputer
3 жыл бұрын
You can check out this video your all problem will be solved. kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
@PeterCChea2 жыл бұрын
Thank you, sir, I gain a lot from this video. Sir please! How can I find the code for clear and coping?
@SahaComputer
2 жыл бұрын
If(C7
@davidogugua19356 ай бұрын
Thank you for the video. But i have a question. You did not explain how you wrote the code in Visual Basic
@SahaComputer
6 ай бұрын
Sorry for that, all the codes are simple. What do you want to know?
@kaleidscope9273 жыл бұрын
Dude u are a genius i wish to see something about automatic time and amount to pay hourly
Very informative and helpful video. I need to know how to automatically calculate total number of holidays each month. Appreciate your kind reply.
@SahaComputer
3 жыл бұрын
if you want it for a single month and whwn you change the month it will change the result according to the month then use this formula, =countif(C4:AG4,">0")
Пікірлер: 1 600
I am so grateful to God Almighty and to the producer of this video, this lesson had push me a steps further while on the path of Success. Like I always maintain, Success is not a destination but rather a PATH. Again I say big thank you yaaah...
@SahaComputer
3 жыл бұрын
You are very welcome
@PrashantMishra-kl8se
2 жыл бұрын
Please share a video in which can calculate half day as .5
@SahaComputer
2 жыл бұрын
If you want to get the total of total present including halfday, then create another column and type =Total Present+(Total Halfday /2)
The year should also have a drop-down list to choose the year and the attendance sheet changes according to the selected year and month. Overall great VDO. Teaching is good, felt that you are in front of me...
@alokghosh9311
4 жыл бұрын
@@SahaComputer One more thing, in the Sunday and Holiday columns should be displayed as "S" and "HL" in every cell automatically, then this will be more attractive...
@mrlodi17
4 жыл бұрын
Appreciate Video! Excuse me for chiming in, I am interested in your opinion. Have you heard the talk about - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a great one of a kind product for getting 7000 plus project management and business templates without the normal expense. Ive heard some amazing things about it and my buddy at very last got astronomical success with it.
@MrAram85
4 жыл бұрын
I have added it by my self
@tsegamihreteab5543
3 жыл бұрын
@@MrAram85 how
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Thanks for reminding me my memories (back 7years from now). When I was working as Admin and I was very familiar with this attendance sheet. Thanks a lot.
@SahaComputer
3 жыл бұрын
Its my pleasure!! Thanks for your comment.
Thanks for The Video Sir, if anyone feels like giving up on this ...it actually works
@SahaComputer
2 жыл бұрын
Thanks for your comment.
You r genuis my brother .. big effort maked .. i ask about attendance .. when i put ( P,A,H) in any months . I find it the same schedule i want each month to be kept separately ..
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
For our office we have sat and sun as weekoff. How can i insert that in formula for both days. As in video it shows only sun. Highly Appreciate your video which will be helpful for everyone. Hatsoff
@aahaarangalicious1893
4 жыл бұрын
I will check today
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Amazing.... immersed in it... realised that 30 min just flew...cos each and every second was informative..simply awesome
@SahaComputer
3 жыл бұрын
Glad you liked it!
@kb7417
3 жыл бұрын
Dear Sir, I have a question if we have to find number of holidays and sundays and listing them in a column ( For example we have 5 sundays and 2 holidays, then Total off day will be 7. But how do we separate sundays and holidays in a column using the above attendance sheet ) ... I did try but I am stuck here. Hope you will find me a solutions. Thanks
Thank you! Great idea
@SahaComputer
2 жыл бұрын
Thanks for your comment.
Bravo,, THIS IS AWESOME,, Great effort thannnnnnnnnnnnnnnnnnnnk u ,, u r Geniusssssssssssssssssssssssssssssssssssssssssssssssss
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Masterpiece................Great effort
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Thank you for this video.
@SahaComputer
2 жыл бұрын
Glad it was helpful!
Great video....exactly what i was looking for....
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Thank you very much Sir. very helpful.. You explanation is very simple for learners like me.. Superb..God bless you👍
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Do you have a sample code for time in, time out for employee/teachers using RFID card (tapping) badly needed pls. thanks in advance
@SahaComputer
3 жыл бұрын
Watch this video kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Very helpful - thanks
@SahaComputer
2 жыл бұрын
You're welcome!
tqvm .... i m follow this step by step till success to complete it.
@SahaComputer
11 ай бұрын
Glad to hear that.
How to find out,when an employee worked for more than 24 hours continuously ...I.e yesterday' day and night and again today's day...because an employee should not continue his duty more than 12 hrs ....so please clarify
@SahaComputer
3 жыл бұрын
This attendance sheet is not time based so it is clearly understood that the employee works within office hours.
@thestranger3772
Жыл бұрын
This is not time tracker this is attendance tracker
Great video and easy to follow! How do I change the year from 2019 to 2020?
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
thank you for sharing. I did it for mine, I save a lot of time!
@SahaComputer
2 жыл бұрын
You're welcome!
Super video sir. Thanks a lot
@SahaComputer
3 жыл бұрын
Thank you sir, please subscribe our channel to get some new and more advance attendance sheet tutorial video will be added.
Great tutorial! I have a question please, the half days are counted as whole days in the total work days column how to fix it.
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Is this only for 2019? What if year changes?
@alial-moqrahi5210
3 жыл бұрын
@@SahaComputer My sincere love & respect to u all
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Thank so much.....this one really helped me..
@SahaComputer
2 жыл бұрын
You're welcome!
Very good video thanks.
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Thank you so much, very helpful.
@SahaComputer
Жыл бұрын
Glad it was helpful!
Thank you very much from Myanmar.
@SahaComputer
2 жыл бұрын
You are welcome
Your work has being useful to me .Thanks and share more for us to learn
@SahaComputer
10 ай бұрын
Glad to hear that
Thank you Sir. The clear button is very important thing to add in sheet like this. Great job
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Informative and easy to follow. Thank you!
@SahaComputer
3 жыл бұрын
You are welcome!
thank u so much for video
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Thanks you bhaiya mein to sab sikh gaya
@SahaComputer
2 жыл бұрын
Great!! agar tum isse better attendance sheet banana chahate ho to niche diye link click karo. kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html kzread.info/dash/bejne/onh7z8-CmNS8Yrw.html kzread.info/dash/bejne/aIWqrJKtYK-aj6Q.html
Thank you so much, I have successfully completed.
@SahaComputer
3 жыл бұрын
Excellent!
Thanks a lot Sir!
@SahaComputer
3 жыл бұрын
So nice of you
I love this!!! It's been nine months since pandemic and I have hard time in manual entry for attendance... Browsing your vids and see what helpful tips I can find... Looking for time in and out in Excel.....
@SahaComputer
3 жыл бұрын
Glad you like them! Watch this update video: kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
thank you sir you are champion you explain it step by step very clearly to understand.may god bless you
@SahaComputer
2 жыл бұрын
So nice of you
Awesome video Clear steps Thanks
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
THANKS FOR THE DETAILED AND SUCH EASY BRIEF
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Thanks a lot for making this video. It has helped me to make an attendance sheet in the Excel.
@SahaComputer
3 жыл бұрын
You are most welcome
Thanks for the Tutorial. Appreciating your great mind
@SahaComputer
3 жыл бұрын
Thanks for your nice comment.
Thank you so very much !!! very well explained I managed to do my own, thank you once again
@SahaComputer
2 жыл бұрын
Glad it helped!
Really very helpful for my mother as she is making attendence chart for her school ! ❤️
@SahaComputer
3 жыл бұрын
Great, It helped. Thanks for the comment.
Very nice teaching step by step, great and very helpful
@SahaComputer
3 жыл бұрын
Glad it was helpful!
Thank you for creating this easy to follow explanation. I also appreciate that it doesn't rely on outside "plug ins" that my jobs network doesn't allow.
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
wow!!! really amazing. Thanks a lot
@SahaComputer
3 жыл бұрын
You are most welcome
Very Usefull thanks
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
THANK YOU SOOO MUCH.
@SahaComputer
2 жыл бұрын
You're welcome!
Your teaching and video is awesome, when are you going to do stock management videos I really need one
@SahaComputer
6 ай бұрын
Very soon!
Fantastic it helped me a lot. Thank you
@SahaComputer
Жыл бұрын
Thanks.
Thank you so much sir for explaining step by step. It's really very very helpful for the beginners. 🙏🙏🙏
@SahaComputer
3 жыл бұрын
It's my pleasure
Good One, Very Impressed Presentation & took time to explain. Understood Easily
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Excellent sir
@SahaComputer
3 жыл бұрын
Many many thanks
Very nice video I make my sheet with the help of your video Thanks sir
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
This would be perfect for my organization.
@SahaComputer
3 жыл бұрын
You should check the latest video in my channel, I have uploaded complete automation on attendance where you can take attendance, manage leaves & payroll every thing is there.
It is very helpful and very informative video thank you very much
@SahaComputer
2 жыл бұрын
You are most welcome
Thank you for making it in English. This sooo helpful
@SahaComputer
11 ай бұрын
You're welcome 😊
you're an excel pro!!
@SahaComputer
3 жыл бұрын
Hi, Thanks for your appreciation. I request you to visit our channel, we have videos on different types of attendance sheet tutorials.
Thank you, for teaching me steps-by-steps.. for a Slow Learner like me this became so easy for me.. Thank you!
@SahaComputer
3 жыл бұрын
Glad it was helpful!
Masterclass...............Thank you.
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
You have explained it so well , there is no question to be asked...thanks so much and see you with new program-mes....Manohar Timothy
@SahaComputer
3 жыл бұрын
So nice of you
Very nice..ty for sharing this
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
very useful tutorial tricks.. thank you bro
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Thank you :)
@SahaComputer
2 ай бұрын
You're welcome! You can watch other attendance sheet in our channel. They are even more better.
Its a great very useful work done by you.can i get this sheet for myself .
@SahaComputer
2 жыл бұрын
Link in the description box.
This taught me a lot, very easy to follow. Thank you so much!
@SahaComputer
2 жыл бұрын
Glad it was helpful!
This Tutorial is amazing. I wished the year should also have a drop-down list so that the attendance sheet changes according to the selected year and month. If possible please send it to us. thanks
@SahaComputer
2 жыл бұрын
You can watch this video, there are several updates: kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
Very good class sir
@SahaComputer
3 жыл бұрын
You can check out this video your all problem will be solved. kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
Thanks a lot sir
@SahaComputer
3 жыл бұрын
You are most Welcome.
Great love it
@SahaComputer
2 жыл бұрын
Thanks
Nice, thank you👍
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Very important sheet for beginner's
@SahaComputer
3 жыл бұрын
Thanks for your comment.
VERY NICE
@SahaComputer
2 жыл бұрын
Thanks
That was a great tutorial. How do I change the year?
@SahaComputer
7 ай бұрын
Please check this video: kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html Please subscribe our channel.
Very useful, Thank you very much.
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Bravo! Very clear, was able to create my own, thank you so much :)
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Hi thanks for this awesome vid.. Here in philippines we have many kinds of holiday.. trying to set regular holidays, special nonworking holidays and special working holidays.. how do i set this in the same timesheet? with conditional formatting as well.. i'm kind of stuck. trying to copy what you do.
@SahaComputer
2 жыл бұрын
You can type your weekends in Weekend list and Holidays in the holiday list in the setting sheet. If you have different holiday list then you cannot do that in this sheet. But still you can do this by keeping all holiday dates in single list.
thanks a lot that exactly what i need i made my form with some additional cell that show boys absents and attendance also girls for each day in the month
@SahaComputer
2 жыл бұрын
Great!
Really Good job!!! God bless you forever . It is very important for our Country( Ethiopia) factory .
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
You're Very Detil Sir... Thank You So Much... 👍🏽👍🏽👍🏽👍🏽
@SahaComputer
3 жыл бұрын
Latest Attendance Tracker Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Hi, thanks for sharing this video, which formula other than data value I can use to select the year of my preference and not the computer system year? I appreciate your help.
@SahaComputer
Жыл бұрын
See video 96.
THANX YOU VERY MUCH
@SahaComputer
3 жыл бұрын
You're welcome!
Sir ours is multi branch multi city.how we can make attendance by branchwise and at the same time consolidated and sync with all branches
Hello. Thank you very much for tutorial. It’s very helpful. I want to create an attendance for only Sunday’s with no holidays. Please can you assist me with some steps on how to do that? Thank you.
@SahaComputer
3 жыл бұрын
You can use this attendance sheet, just exclude the VBA.
Thanks for the wonderful information shared through this video.
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Nice one
@SahaComputer
3 жыл бұрын
Thanks
Oh wow!! You’re amazing!
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
it was really helpful, thanks a lot and God bless you
@SahaComputer
3 жыл бұрын
Latest video on Attendance Sheet, Payroll Sheet and Pay Slip, All In One: kzread.info/dash/bejne/g3ymj5aQo7TVXag.html
Awesome..
@SahaComputer
3 жыл бұрын
Thanks 🤗
This is aweeeeeesome Marvellous Geniuuuuuuuuuuuusssssssssssssss Thankssssssssssssss Allot sir
@SahaComputer
3 жыл бұрын
You are most welcome 😊
Thank you. it's work now
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Really helpful. Thank you soo much. I need to know one more thing. Can any one help me out. If we have one more employee added after doing all this process. We need to do the same process again or is there any shortcut.
@SahaComputer
2 жыл бұрын
You can add as much employee as you want but in this tutorial we have taken the range upto 10 employees , you can take it for 100 employees.
@naturecreativity2838
2 жыл бұрын
I have also taken the range upto 15. But i want to increase upto 90. My question is. I need to do the process from the start or is there any shortcut, i want to add employees to same sheet and wouldn't do the whole process again.
@SahaComputer
2 жыл бұрын
Just drag down the formula with fill handle upto row 90. Check new attendance sheet: kzread.info/dash/bejne/onh7z8-CmNS8Yrw.html
Super good teacher. Thanks for explaining in details. Appreciate it. You have kind heart. Thank you so much sir.
@SahaComputer
3 жыл бұрын
You can check out this video your all problem will be solved. kzread.info/dash/bejne/gIl_mrKRfMnNl9I.html
Thank you, sir, I gain a lot from this video. Sir please! How can I find the code for clear and coping?
@SahaComputer
2 жыл бұрын
If(C7
Thank you for the video. But i have a question. You did not explain how you wrote the code in Visual Basic
@SahaComputer
6 ай бұрын
Sorry for that, all the codes are simple. What do you want to know?
Dude u are a genius i wish to see something about automatic time and amount to pay hourly
@SahaComputer
3 жыл бұрын
I will make one.
So Nice video 💝
@SahaComputer
2 жыл бұрын
Thanks for your comment.
great job sir
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Ok thanks sir😊
@SahaComputer
3 жыл бұрын
Welcome
excellent programmer. In schools there are two years in the academic calendar. what change should be made ?
@SahaComputer
3 жыл бұрын
Latest Attendance Video: kzread.info/dash/bejne/Y6h7tdKij5eoj9I.html
Very informative and helpful video. I need to know how to automatically calculate total number of holidays each month. Appreciate your kind reply.
@SahaComputer
3 жыл бұрын
if you want it for a single month and whwn you change the month it will change the result according to the month then use this formula, =countif(C4:AG4,">0")