Thank you very much for this video. Please i will love to know, how do you design an attendance tracker that can show mutiple employees total hours worked in a week and a month, using a singular sheet.
You are a great teacher. I enjoyed your lesson. Please, how can I do this successfully using mobile android? I have already started but got stuck at inputing the month, there are no such things as data source on mobile.
Hi, problem with the month. if you change the month the information will all stay there. as example if the 1st September 2021 i said that employee A is in Holiday and i change the month in febraury, the tracker will say that the employee is on holiday on 1st of february :/ hope is make sense XD
Thanks for this. But can you not create a one sheet for all the month such that if you move from month to month within the same sheet, the data of the previous month will disappear so you can enter data for the current month you are on.
@@jamesleleji9470 hello, unfortunately the function we are looking for needs macros to be enabled. Which google sheet doesn't have. It has something else which is called Apps Scripts.
@@jamesleleji9470 Here's the video I found that could somehow work, but I havent tried coding from macros to apps script. ruclips.net/video/OPypfBBUGXo/видео.html
To lock, use the sheet protection option in Home >Format>Protect Sheet If you want second method of creating , this video might help: ruclips.net/video/_SWcjE8S8hk/видео.htmlsi=EOp0OEDfbGrsKea7
Thank you for guidance. ❤
Welcome
This was so helpful. I am shocked!!! I took my time and went step-by-step with you, and I now have a huge amount of respect for excel!! Thank you.
Thank you ❤️
Superb , was very helpful and explained perfectly.
Glad it was helpful!
Thank you so much!
You're welcome!
Thank you very much for this video. Please i will love to know, how do you design an attendance tracker that can show mutiple employees total hours worked in a week and a month, using a singular sheet.
is there a way to retain data per month? or do we have to always clear it manually every time we change the month?
You are a great teacher. I enjoyed your lesson.
Please, how can I do this successfully using mobile android? I have already started but got stuck at inputing the month, there are no such things as data source on mobile.
I love you, you are a good teacher. Please, how can I create a list on mobile?
This is has been very helpful thank you. How do I highlight both Saturday and Sunday please
For highlight all Sunday, repeat the same conditional formatting as I do for Saturday 🙏
Thank you sir
so helpful on my project
I did it. ☺️ Thanks but I hope there is a way that no need to copy the sheet 😅 but it's good
Welcome
I love this video! ♥️♥️♥️
Thank you
Hi, problem with the month. if you change the month the information will all stay there. as example if the 1st September 2021 i said that employee A is in Holiday and i change the month in febraury, the tracker will say that the employee is on holiday on 1st of february :/ hope is make sense XD
After changing the month, previous data needs to be cleaned at the beginning of new month, keep backup every month data at the end of month
مرسی
the problem is that we cannot put mor than 5 employees did you have a solution. for that .. thanks
This is just for example, u can expand the row as required
Good work bro
Thank you
Hi could you please share the a prepared Attendance Tracker??
Thanks for this. But can you not create a one sheet for all the month such that if you move from month to month within the same sheet, the data of the previous month will disappear so you can enter data for the current month you are on.
have you found the solution to this? sorry 4 months late hehe
@@Psygnosis I have not found a solution yet. Can you help?
@@jamesleleji9470 hello, unfortunately the function we are looking for needs macros to be enabled. Which google sheet doesn't have. It has something else which is called Apps Scripts.
@@jamesleleji9470 Here's the video I found that could somehow work, but I havent tried coding from macros to apps script.
ruclips.net/video/OPypfBBUGXo/видео.html
@@Psygnosis Thanks, i will try it.
How can I lock the attendance? I don't want it to be created by sheets.
To lock, use the sheet protection option in Home >Format>Protect Sheet
If you want second method of creating , this video might help: ruclips.net/video/_SWcjE8S8hk/видео.htmlsi=EOp0OEDfbGrsKea7
Would it be possible to send this template?
This you can download from
www.spreadsheetlearning.com
Sir
If we fill Presence and Absence manually than it's not Automatic Attendance Sheet
Let's say it half Automatic then🙂
@@spreadsheet_power
Watch full video Fully Automatic Attendance Sheet in Excel without VBA than you get the answer of your question
Full leave ke liye
How to download this file
Please write a mail to spreadsheetforu@gmail.com for template
Sir Sand me excel file please
It is possible to send me the file ?thanks