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
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.
It's a beautiful work, I created this too, however the only problem I am facing is I am unable to get the data in the database sheet when I mark them in "Mark Attendance" sheet. What could be the issue? Pls assist.
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?
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?
In the attendance sheet instead of using alphabet can we use numbers? And if yes how can we calculate normal hour and working on holidays? And can we also identify the data for a whole year?
@@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.
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.
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...
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.
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
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
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.
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"")
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.
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
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)
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, 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
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
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
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.
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
Really glad I watched this Tutorial. Thanks
Glad it was helpful!
The King of excel is back with yet another excel learning. Awesome video 10/10 stars sir
Thanks for your valuable feedback
This was awesome! I can't wait to watch more of your videos!
Yay! Thank you!
Hi. This was very useful. Thanks
Most welcome
Really you!are a wonderful teacher. You boosted my excel knowledge and confidence. Thank you for sharing your knowledge .
Thanks for your valuable feedback🙏
Waw..very well explained Sir.. Hats off to you..
Thanks for your valuable feedback
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
Thank you very much for the wonderful explanation
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 tutorial
Glad you think so!
Hello Boss Thank you but my dates figures came blank on the P,A,L after using the vlookup formulas how did you arrange dates on the data base?
Awesome tutorial
Thanks for your valuable feedback
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
Nice explanation sir.. trillions of thanks to you 🙏
Thanks for your valuable feedback
Mantab,, 👍
Banyak belajar saya dari channel ini untuk bahan di channel ku,, 😊
Wonderfully explained. Superb work. 👍
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
Great work!
Thanks for your valuable feedback
Excellent
Thanks for your valuable feedback
Great! Can you make the file output FIFO next time, Sir?
GREAT VIDEO
Thanks for your valuable feedback
on the mark attendance sheet. Anyway to refresh data based on a certain supervisor? Thanks
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
Nice , very useful , clear explanation,i need this template,how I can get, please let me know
Thanks for your valuable feedback. Link is given in video description box or visit our website www.PK-AnExcelExpert.com
@@PKAnExcelExperti couldn't not able download template,it is pay able let me know,or else please share template download link plz
Nice tutorial, really appreciate the effort, but lost on the macro part
Sorry about that
Very useful helpful video sir
Thanks for your valuable feedback
VERY GOOD
Thanks
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
you make excellent projects with unbelievable designing in excel
you have any rfid based student attendance system with sms alert with database ?
Amazing. But could you please help me out in the Visual Basic. There are no codes showing in my worksheet.
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.
lajawab
Thanks for your valuable feedback
Great effort, If any one leave job, so then how can we mange?
Fantastic sir and thank you.
Thanks for your valuable feedback
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
may I ask where I can get the formula for the refresh and mark attendance?
Is it possible to create an attendance sheet like this from several attendance sheets generated from a id card system?
Thanks bro u are the best
Thanks for your valuable feedback
It's a beautiful work, I created this too, however the only problem I am facing is I am unable to get the data in the database sheet when I mark them in "Mark Attendance" sheet.
What could be the issue?
Pls assist.
Brilliant👍.... Thank you...
Thanks for your valuable feedback
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?
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?
I need this format sir
In the attendance sheet instead of using alphabet can we use numbers? And if yes how can we calculate normal hour and working on holidays? And can we also identify the data for a whole year?
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.
Excel complete Training basic to advance level
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?
Good morning everyone, pls what is the unique ID for the insertion of data in the February and subsequent month
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:
ruclips.net/video/PnZrH-fvMto/видео.html
ruclips.net/video/gu2PRtl-mzc/видео.html
Thanx
Most welcome
will all these features work on OneDrive share?
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...
Hi sir
In the same attendance can you set payroll sheet and payslip it's more helpful
Your work is always comendable. Thank you.
Thanks for your valuable feedback
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!!!
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.
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
How I can get the vb script I. Mark attendance sheet
Hi great job PK. how to fo if the employee work Halfday?can you please help?thank you in advance
super
Thanks for your valuable feedback
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
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 please make video in Hindi also
Sir half day work inculcated
One more video attendance sheet present &overtime to database
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
hi, i just wanted to know the difference between database and Mark Attendance sheet?
Sir can we update timing late coming
Is there a way to obtain the macro scripts?
I also want this, have you got it
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
How can we check total leaves and present days in annual for one by one each employee.
Good
Thanks
can i do this in tableau?
Sir . in Mark Attendence do we have to add Month Days Manually
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....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"")
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.
Getting error with Set dsh = This workbook.sheets("Database") any help please
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
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)
Hi! Mark Attendance button is not functioning to update the data when it already exists. It is not reflecting in the Database tab.
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?
Bro main ne is sheet main uae holidays add karni hai. wo kase add kare gaye. Please ye bata do
how i can adjust government holidays in this sheet ?
Can u send this format 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
Can anyone please tell me , how I mentioned these data in Microsoft visual basics for applications, i couldn't understand that part, I stuck here
Please clear my query
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
Hi sir
Is there any chance to get school management software
Thank you sir
Is it possible in Google sheet?
Sir excel 2007 me chal sakta hai kya
It is possible to download this file
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
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
Hello sir one request for you plz make school Time table for school to reduce teacher committee work.... Plz accept this request 🙏 sir 🙏🙏🙏🙏
How can I add daily overtime of my employees if any ?
I followed everything but it's not working.
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.
Sir, This is possible in Google spreadsheet..?
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