Automated Attendance Sheet in Excel
Vložit
- čas přidán 5. 12. 2020
- #AttendanceSheet #ExcelTemplate
Hello Friends,
In this video, you will learn how to create an automated attendance sheet template in Microsoft Excel. We have used VBA to add the attendance. There 5 different sheets available in this template-
1-Mark Attendance
2-Attendance Sheet
3-Employee Master
4-Database
5-Setting Sheet
Download the practice files from below given link:
www.pk-anexcelexpert.com/auto...
Download the Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...
The King of excel is back with yet another excel learning. Awesome video 10/10 stars sir
Thanks for your valuable feedback
Thank you very much for the wonderful explanation
Thanks for your valuable feedback
Really you!are a wonderful teacher. You boosted my excel knowledge and confidence. Thank you for sharing your knowledge .
Thanks for your valuable feedback🙏
This was awesome! I can't wait to watch more of your videos!
Yay! Thank you!
Nice explanation sir.. trillions of thanks to you 🙏
Thanks for your valuable feedback
Wonderfully explained. Superb work. 👍
Thanks for your valuable feedback
Brilliant👍.... Thank you...
Thanks for your valuable feedback
Very nice explanation 👌 Thanks for educating the world 🙏
Thanks for your valuable feedback
I am going to apply the same for my office of 1164 employees
Really glad I watched this Tutorial. Thanks
Glad it was helpful!
Waw..very well explained Sir.. Hats off to you..
Thanks for your valuable feedback
Not sure if it has been covered elsewhere, but there is a need also to introduce statutory holidays besides the weekly offs.
Great! Can you make the file output FIFO next time, Sir?
Great work!
Thanks for your valuable feedback
Fantastic sir and thank you.
Thanks for your valuable feedback
Very awesome sir ji, wonderful presentation and truly magical.. I like it very much. Thank you
Thanks for your valuable feedback
@@PKAnExcelExpert sir please made a appointment entry model and also for store goods in or out showing also other stuff in that profit loss etc if possible. I know it is not a big deal for you the talent you have. I eagerly wait so see those.
Mantab,, 👍
Banyak belajar saya dari channel ini untuk bahan di channel ku,, 😊
Hi Mr PK, thank you for the nice video, one question, how to include holiday and hilight it on the date such as saturday and sunday, thank you
Thanks bro u are the best
Thanks for your valuable feedback
Awesome tutorial
Thanks for your valuable feedback
Thank you for your great effort in creating these video's to helping others in need.
I was creating an attendance sheet following your excellent videos, but i need help if possible in modifying
the below formula considering a leap year having 29 days and avoid calculating additional days in my attendance sheet.
=IF(Show_weekends,AG8+1,WORKDAY.INTL(AG8,1,Weekend_option)) current formula in February day 29.
Very Nice. If attendance is marked on WO days by mistake, we need to edit database only. To prevent this mistake happening, in Mark Attendance sheet, conditional format to indicate as "Holiday" if such dates are entered. This would make it more helpful. Every aspect seems to have been covered. Cheers. RK
Thanks for your valuable feedback
Hi. This was very useful. Thanks
Most welcome
Very useful helpful video sir
Thanks for your valuable feedback
Your work is always comendable. Thank you.
Thanks for your valuable feedback
you make excellent projects with unbelievable designing in excel
you have any rfid based student attendance system with sms alert with database ?
Hi....i used the formula for conditional formatting to apply borders based on array but it is leaving some rows unformatted....can you elaborate the criteria to get them formatted as well....here is the formula I am talking about =AND($A6"",A$5"")
Thank you very much for your videos.
Shall I ask a doubt plz...
I have a work sheet with 25 columns. I need to display some selected columns in a list box. For example: From the 25 columns , I want to take datas of column number 3, 7, 13 & 24.
If it is possible, plz let me know the details of codes. Thank you...
GREAT VIDEO
Thanks for your valuable feedback
Hi, really like all ur videos..can i request u to make a video on how to automatically update stock prices on our excel sheet..? Windows 10
Hi Sir, Excellent way you teaching first. I am happy Your program is excellent and professional. its neet and wonderful. God bless you more and more.
Thanks for your valuable feedback
Hi sir
In the same attendance can you set payroll sheet and payslip it's more helpful
Great explanation Sir! One other knowledgeable video,
Thanks for your valuable feedback
Thank you for good work please upload more like this one's
Welcome. Excellent
Thanks for your valuable feedback
may I ask where I can get the formula for the refresh and mark attendance?
Amazing. But could you please help me out in the Visual Basic. There are no codes showing in my worksheet.
great tutorial
Glad you think so!
This was very helpful,
Somehow when I change the month in the drop down the attendance letters remains from previous month. How do I fix that?
Excellent
Thanks for your valuable feedback
on the mark attendance sheet. Anyway to refresh data based on a certain supervisor? Thanks
Nice tutorial, really appreciate the effort, but lost on the macro part
Sorry about that
Hello, I'm reviewing the video and it looks like it is exactly what I am looking for. However, I like to keep the names in alphabetical order (Last name), to find quicker. When I add a new client to the master list, it doesn't populate into the attendance sheet. Is there a difference formula to use?
Sir . in Mark Attendence do we have to add Month Days Manually
hi, i just wanted to know the difference between database and Mark Attendance sheet?
VERY GOOD
Thanks
One more video attendance sheet present &overtime to database
I get an error when I try to run the Mark Attendance macro. I don't have a supervisor column, so I simply shifted Date over, and I have my date rows starting on row 4 not row 3, so I used that but the macro fails at this part: dsh.Range("D" & lr).Value = sh.Range(4, c).Value fails. Any advice?
Hi great job PK. how to fo if the employee work Halfday?can you please help?thank you in advance
lajawab
Thanks for your valuable feedback
Is it possible to create an attendance sheet like this from several attendance sheets generated from a id card system?
Great effort, If any one leave job, so then how can we mange?
Hello. Could you please help me in finding a response to my inquiry that is how can i generate excel workbook from templates ? Is there any free add-on can help? Or something like that. Thanks in advance
Really great video sir, your videos always boost my Excel knowledge and confidence.
But sir In this Automated Attendance sheet if any existing employee leaves the organization and I delete his name from employee master sheet, it is getting deleted from previous months attendance as well. Also if I am going to add new employee's name in Employee master it is showing in previous months attendance as well. How can we fix this sir.
Hello you found answer with question please let me know too ..I'm going into same problem
Hi, how about if we want it to filter by different departments/teams to show? so having a dropdown department cell under in where you choose the department and the employees of that department show up?
Thanx
Most welcome
super
Thanks for your valuable feedback
Hi not sure what i am doing wrong but I applied your formula for shading Sunday and Saturday but for some reason it only applied to the Sunday. Can you please identify where I went wrong? Thx =OR(TEXT(I$5,"DDDD")=Settings!$C$2,TEXT(I$5,"DDDD")=Settings!$C$3)
Sir, This is possible in Google spreadsheet..?
will all these features work on OneDrive share?
Thank you, i ran into one issue for some reason [i can't find my error ] it would not update the attendance when I mark the attendance - HELP!!!
Good morning everyone, pls what is the unique ID for the insertion of data in the February and subsequent month
How can we check total leaves and present days in annual for one by one each employee.
This is really helpful! Just wondering, how can we manage this sheet in real time? for instance, if we change month you can still see same data for other months. i'd like to get data save n change for each month if possible. how can we do that? that'll make everyone life easy. hope this make sense.
Please see below videos:
czcams.com/video/PnZrH-fvMto/video.html
czcams.com/video/gu2PRtl-mzc/video.html
how do I get the data to change with the month? or do i always have to make a copy and save each month?
Sir can we update timing late coming
can i do this in tableau?
hi sir your attendance is good .this attendance use for our school student daily attendance
.but question ,our school Saturday is working day and second question is how to highlight holiday in attendance sheet.plz replay.
Dear Sir,
Can we do all these things trough Google Spreadsheet.
please reply because we are sharing Excel sheet with someone so he can edit in our sheet
verry good project
I have 2 issues:
1-when I clik Mark Attendance to transfer to Data Source it tack long time
2-the Data is transfered even double ; any solution please
Amazing sir. Can you please share the Excel
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
How can I add daily overtime of my employees if any ?
Dear Sir your format is great if you don't mind we need a column after each day. Where do we put the value if we are working overtime. So you are requested to kindly add my point if possible. Thanks
Will upload soon
I need this format sir
Good
Thanks
Sir excel 2007 me chal sakta hai kya
when i try to install this tool my windows get stop working....How can I install this tool?
Sir half day work inculcated
How I can get the vb script I. Mark attendance sheet
Hello Sir, I want a tracker sheet in which both attendance and leave are automatically recorded in the same excel sheet and can also be viewed. Please help me.
Hi sir
Is there any chance to get school management software
Thank you sir
Hi,
I am finding difficulty in leave tracker where you search with emp id not name, we remember names not id's, can u make leave tracker with name search
Mr PK, would you pls let us know how to install and add-in the PK's Utility Tool V2 into excel sheet? The downloaded file is in zip and then it doesn't lead to any settings. Previously asked by someone already but you have not replied the answer Thank you
He will never give any answer of your questions... this is his record
Hi! Mark Attendance button is not functioning to update the data when it already exists. It is not reflecting in the Database tab.
Bro main ne is sheet main uae holidays add karni hai. wo kase add kare gaye. Please ye bata do
Excel complete Training basic to advance level
Sir please make video in Hindi also
=and($A6"",OR(TEXT(G$5,"DDDD")=Setting!$E$2,TEXT(G$5,"DDDD")=Setting!$E$3))
While using this line for highlight getting error " you cannot use reference to other worksheets or workbooks for conditional formatting criteria"
Please tell me the issue could be?
Everythig looks good, But i have one question sir, you have updated April month data once end April month data if i want to add May month data what i need to do.Do i need to delete April data from Mark attaendence data and i need to add May month right?is there any automation for to change month once end in Mark attendence.
Did you find any solution of this.
Is it possible in Google sheet?
Getting error with Set dsh = This workbook.sheets("Database") any help please
Hi tried the practice sheet but on the Attendance Sheet when i try to change the the dropdown, it says its a protected sheet and i might be asked to enter a password. Help pls i need this template as it is perfect.
how i can adjust government holidays in this sheet ?
since month is shown
how to change year example if 2021 is finished how to do 2022
all of it in one simple sheet
please kindly guide
thanks
A little help here! It doesn't update any of the attendance after day 7, it seems the macro is designed that way, can anybody confirm?
Can u send this format sir
How we are half day count in this sheet
Is there a way to obtain the macro scripts?
I also want this, have you got it
thank you Mr kumar
i have question
can i add scroll bar to pivot chart?
not timline or slicer
i try hard and didn't success
also i ask many people but also don't reply
thank you
I will try to make such video very soon
@@PKAnExcelExpert you are superb
I wait you my friend , show us your skills please
Sir tools ko kya 2007 me not show yes ya no
🤯🤯🤯
Hello sir one request for you plz make school Time table for school to reduce teacher committee work.... Plz accept this request 🙏 sir 🙏🙏🙏🙏