New to Excel and I found this video to be the best for what I needed. How would I create a new monthly report without losing the old one? I need to go back and watch again in case I missed that. Thank you for this.
Hi Steven. Glad you found the video useful. Suggest you do a 'Save' on your current work and then start on Month 2 etc. That way you will always have a backup of your work. :-)
First off, a big shoutout for this super helpful explanation! I've checked out a bunch of others, but this one really hits the spot. But, here's a little something I've been thinking about. I work with temporary staff quite often, and it would be super cool if we could automate the removal of employees from the schedule once their employment end date has passed. For instance, if someone's last day is in March, it'd be awesome if they automatically vanished from the schedule starting April. This would save me some manual work and ensure the schedule stays accurate without me having to tweak it. Any chance this auto-removal feature could be on the cards for future updates? It'd be a game-changer for folks like me who juggle schedules and temporary staff all the time. Thanks again for this fantastic resource!
Hi, Thanks for your comments and interest. Yes, you could do this in several different ways, but how about if you just HIDE the LINES of those who have left. Far easier than writing a lot of complicated code. :-)
I am also interested in how to formulate partial days (for when staff use vacation time or BOT for things like appointments or being late, etc.). Please tag me when you create the future template! @@MrSpreadSheet
Thank you Mr. Spreadsheet. I created our own attendance sheet but I have a problem adding some data particularly when I tried editing the leavetypes. Can I still edit "define name" in the formula?
Helloo Mr. Spreadsheet I have compiled the Employee Attendance for March 2022, your instructions were excellent! How do I apply the spreadsheet that is now completed for each month of the year?
Hello… I am also looking for an attendance tracker that tracks hourly attendance/day (ie: track time missed for late arrivals etc.). I don’t see it in your list of videos yet. Where can I find it please?
When I make a new sheet for another month, is there anyway I can have it separate from the original? Right now, everything from month one will carry over to the next month.
This is a good tutorial, but you really have made it even longer than it should be, you don't need to make 'NameRanges', you can just Absolute Cells, Rows and/or Columns ... but of course everyone does it differently , I would just find this easier and quicker by locking cells rows and columns. But saying all that, you explain things very well :) Keep it up.
All of my total of leave types are working except for 1. My countif formula is correct, however it is not capturing that specific leave type. How can this be fixed!
I just finished watching the employee attendance video, which was terrific. However, I will never remember all the steps, would there be a written step by step sheet that I could print out?
@@MrSpreadSheetwould it be possible to create 12 different tabs for each month of the year on the same spreadsheet? Or would somethings need to be changed if I do that? Thanks so much!
Hi, The file is designed to be in Monthly format and the date formulae are consistent with this. You could set a yearly range, but obviously this will make the file more complex :-)
Define name for each row is not so great as you were changing the formulas manually. 10 rows could be done easily, but what if we had more. It's not automation I believe. Thank you for the share thou.
![How to create a Quotation System using an Excel spreadsheet - [create your own Template]](http://i.ytimg.com/vi/p5miIyPT_MI/mqdefault.jpg)
Hello Mr. Spreadsheet,
Thank you very much this video was a great help
You are welcome! :-)
New to Excel and I found this video to be the best for what I needed. How would I create a new monthly report without losing the old one? I need to go back and watch again in case I missed that. Thank you for this.
Hi Steven. Glad you found the video useful. Suggest you do a 'Save' on your current work and then start on Month 2 etc. That way you will always have a backup of your work. :-)
First off, a big shoutout for this super helpful explanation! I've checked out a bunch of others, but this one really hits the spot.
But, here's a little something I've been thinking about. I work with temporary staff quite often, and it would be super cool if we could automate the removal of employees from the schedule once their employment end date has passed.
For instance, if someone's last day is in March, it'd be awesome if they automatically vanished from the schedule starting April. This would save me some manual work and ensure the schedule stays accurate without me having to tweak it.
Any chance this auto-removal feature could be on the cards for future updates? It'd be a game-changer for folks like me who juggle schedules and temporary staff all the time. Thanks again for this fantastic resource!
Hi, Thanks for your comments and interest. Yes, you could do this in several different ways, but how about if you just HIDE the LINES of those who have left. Far easier than writing a lot of complicated code. :-)
Wow I was really struggling to get the template to automatically display the colours, you're video saved me a lot of frustration! Thanks a lot!
Glad it helped!😊
This has helped me so much thank you. I do have a question though, how do I formulate it to include half days for annual leave as well as full days?
Hi, Great suggestion. I will incorporate this into any future templates on this subject matter :-)
I am also interested in how to formulate partial days (for when staff use vacation time or BOT for things like appointments or being late, etc.). Please tag me when you create the future template! @@MrSpreadSheet
Great so interesting subject
Glad you enjoyed it :-)
Well detailed. Good for us who are slow learners
Thanks Zettie, glad you found it useful :-)
So helpful!
Glad it was helpful!
Thank you Mr. Spreadsheet. I created our own attendance sheet but I have a problem adding some data particularly when I tried editing the leavetypes. Can I still edit "define name" in the formula?
Hi Moneth, You can check your work against the original. See the download guide video ruclips.net/video/m7Zf8_UWPGQ/видео.html 😊
Helloo Mr. Spreadsheet
I have compiled the Employee Attendance for March 2022, your instructions were excellent! How do I apply the spreadsheet that is now completed for each month of the year?
Hi, You will need to create new Monthly tabs and then use the Date Formulae with the Months you require :-)
Hi,thanks for this tution, how i continue for month that follows,april,may,june etc..
Hi G m, copy the whole file onto 12 separate worksheets, then change the Month Date on each one :-)
Hello Mr. Spreadsheet,
Love your videos. Can you do a weekly time sheet for hours worked?
Hi Sophia, that's a good idea, I'll put it on the list :-)
Hello… I am also looking for an attendance tracker that tracks hourly attendance/day (ie: track time missed for late arrivals etc.). I don’t see it in your list of videos yet. Where can I find it please?
Hi, thanks for these episodes.
Can you do a students attendance sheet as well.
Hi Ismaeel, You can use this one for this :-)
Nice video 💝💝💝
Thanks 🤗
It was useful yes
Is there a way so the each person has the total calculated per reason of absence?
Thanks in advance
Hi Dbzitb, I think it already does that ?
When I make a new sheet for another month, is there anyway I can have it separate from the original? Right now, everything from month one will carry over to the next month.
Hi, you could simply use a fresh sheet for each month, that way you start from scratch each time :-)
thanks again for the video what would be the best way to add new employees while keeping them in alphabetical order thanks
Hi Griss, I would use the SORT routine.
@@MrSpreadSheet so if I add a a new employee
Will I have too add them to each month or is there a way too add them too every sheet at once
This is a good tutorial, but you really have made it even longer than it should be, you don't need to make 'NameRanges', you can just Absolute Cells, Rows and/or Columns ... but of course everyone does it differently , I would just find this easier and quicker by locking cells rows and columns.
But saying all that, you explain things very well :)
Keep it up.
Thanks Scott, Yes, I guess we all use different methods.
How can I do this?
All of my total of leave types are working except for 1. My countif formula is correct, however it is not capturing that specific leave type. How can this be fixed!
You can download a copy at www.MrSpreadSheet.com and check your work against this :-)
I just finished watching the employee attendance video, which was terrific. However, I will never remember all the steps, would there be a written step by step sheet that I could print out?
Hi Gerard, You can check your work against the original. See the download guide video ruclips.net/video/m7Zf8_UWPGQ/видео.html 😊
I need needed the tutorial for the borders took to define parameters and how to choose color scheme lol!
But thanks so much!
Well done ...
@@MrSpreadSheetwould it be possible to create 12 different tabs for each month of the year on the same spreadsheet? Or would somethings need to be changed if I do that? Thanks so much!
Hi! Is there a way to do a YTD absence column that keeps a current tally of days off?
Hi, I'm sure that could be done, I suggest you extend the absence options, or maybe substitute one of the current ones. :-)
Hello Mr. Spreadsheet,
I have a problem when I change the month it shows the data for the last month in the current month. What should I do?
Hi Raafat, You can check your work against the original. See the download guide video ruclips.net/video/m7Zf8_UWPGQ/видео.html 😊
@@MrSpreadSheet Hello Mr Spreadsheet, I am having the same issue. I am unable to see the download guide as it comes up as a private video.
I want to use this month but the formula doesn’t work. I changed the 3 to a 7 but something isn’t working
Hi, You can check your work against the original, a download is available at www.MrSpreadSheet.com :-)
Thank you sir🥰
Always welcome :-)
I need to create a whole year in one sheet?
Hi, The file is designed to be in Monthly format and the date formulae are consistent with this. You could set a yearly range, but obviously this will make the file more complex :-)
I would like a copy of the completed spreadsheet emailed to me how do I go about doing this?
Hi, downloads are available at www.MrSpreadSheet.com:-)
Thank you it's very useful videos, Can you please send me a copy of the completed spreadsheet
Thank you
Hi Sherif, The file you have requested can be obtained by following the guide in this video ruclips.net/video/m7Zf8_UWPGQ/видео.html 😊
How can I move everything made from this month to the next month?
The easiest way is to replicate your work :-)
Does this mean starting from scratch each month? 😮
How can you add all sick days for the whole year
Hi Griss, sometimes a simple Plus Month1 + Month2 is all that is needed. :-)
Hello,
I would like a copy of the finished product.
Thank you
Hi Diana, studio.ruclips.net/user/videow9xdAeYSkxg/edit
Why won't from the beginning add up the days. From H to Al?
Hi Ryan, you can check your work against the original. Download is available at www.MrSpreadSheet.com 😊
the date formula didnt work for me
Hi Olivia, You can check your work against the original. See the download guide video ruclips.net/video/m7Zf8_UWPGQ/видео.html 😊
Can you please share the spreadsheet file, I have done the required.
Hi Deep, please message me on FB :-)
@@MrSpreadSheet nvm.. I will send dm in fb
I am getting the weekday as Wednesday and not Tuesday for the same year
Hi, you can check your work against the original. A free download is available at www.MrSpreadSheet.com
can i get the final result one sir?
Hi David, please follow the instructions at the end of the video :-)
My first two absence types are not working :(
Hi Ivette, You can check your work against the original. See the download guide video ruclips.net/video/m7Zf8_UWPGQ/видео.html 😊
Exemplary performed
Thanks Asa, glad you found it useful. :-)
Define name for each row is not so great as you were changing the formulas manually. 10 rows could be done easily, but what if we had more. It's not automation I believe. Thank you for the share thou.
Hi Syed, agreed, here is the link to the product download, you can check your work against the original. 😊 ruclips.net/video/m7Zf8_UWPGQ/видео.html
never mind sorry
:-)
HI, WITH THE VLOOKUP FORMULA WHERE IT SHOWS DAY INSTEAD OF NUMBER 3. IT SHOWS WED INSTEAD OF TUE. CAN U HELP
Hi Chandhrashekar, You can check your work against the original. See the download guide video ruclips.net/video/m7Zf8_UWPGQ/видео.html 😊