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
@@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.
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.
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.
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?
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, 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?
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 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
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)
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
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....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"")
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.
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?
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
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.
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
Really glad I watched this Tutorial. Thanks
Glad it was helpful!
Really you!are a wonderful teacher. You boosted my excel knowledge and confidence. Thank you for sharing your knowledge .
Thanks for your valuable feedback🙏
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!
Waw..very well explained Sir.. Hats off to you..
Thanks for your valuable feedback
Thank you very much for the wonderful explanation
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
Hi. This was very useful. Thanks
Most welcome
Wonderfully explained. Superb work. 👍
Thanks for your valuable feedback
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 explanation sir.. trillions of thanks to you 🙏
Thanks for your valuable feedback
Mantab,, 👍
Banyak belajar saya dari channel ini untuk bahan di channel ku,, 😊
Great explanation Sir! One other knowledgeable video,
Thanks for your valuable feedback
Thank you for good work please upload more like this one's
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
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 tutorial
Glad you think so!
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.
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
you make excellent projects with unbelievable designing in excel
you have any rfid based student attendance system with sms alert with database ?
Welcome. Excellent
Thanks for your valuable feedback
Great! Can you make the file output FIFO next time, Sir?
Great work!
Thanks for your valuable feedback
GREAT VIDEO
Thanks for your valuable feedback
on the mark attendance sheet. Anyway to refresh data based on a certain supervisor? Thanks
Not sure if it has been covered elsewhere, but there is a need also to introduce statutory holidays besides the weekly offs.
Your work is always comendable. Thank you.
Thanks for your valuable feedback
Very useful helpful video sir
Thanks for your valuable feedback
Great effort, If any one leave job, so then how can we mange?
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
Nice tutorial, really appreciate the effort, but lost on the macro part
Sorry about that
Excellent
Thanks for your valuable feedback
lajawab
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.
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:
th-cam.com/video/PnZrH-fvMto/w-d-xo.html
th-cam.com/video/gu2PRtl-mzc/w-d-xo.html
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?
Amazing. But could you please help me out in the Visual Basic. There are no codes showing in my worksheet.
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
Is it possible to create an attendance sheet like this from several attendance sheets generated from a id card system?
Fantastic sir and thank you.
Thanks for your valuable feedback
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?
Thanks bro u are the best
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
Brilliant👍.... Thank you...
Thanks for your valuable feedback
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...
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?
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?
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
Hi great job PK. how to fo if the employee work Halfday?can you please help?thank you in advance
I need this format sir
may I ask where I can get the formula for the refresh and mark attendance?
super
Thanks for your valuable feedback
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
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.
Hello you found answer with question please let me know too ..I'm going into same problem
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
Hi sir
In the same attendance can you set payroll sheet and payslip it's more helpful
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
Sir can we update timing late coming
Thanx
Most welcome
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 . in Mark Attendence do we have to add Month Days Manually
Good morning everyone, pls what is the unique ID for the insertion of data in the February and subsequent month
how do I get the data to change with the month? or do i always have to make a copy and save each month?
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
How I can get the vb script I. Mark attendance sheet
One more video attendance sheet present &overtime to database
can i do this in tableau?
Excel complete Training basic to advance level
hi, i just wanted to know the difference between database and 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 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"")
Sir please make video in Hindi also
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
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.
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?
Can u send this format sir
Hi! Mark Attendance button is not functioning to update the data when it already exists. It is not reflecting in the Database tab.
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 half day work inculcated
Getting error with Set dsh = This workbook.sheets("Database") any help please
Hello sir one request for you plz make school Time table for school to reduce teacher committee work.... Plz accept this request 🙏 sir 🙏🙏🙏🙏
Sir, This is possible in Google spreadsheet..?
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.
Is it possible in Google 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
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
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
How can we check total leaves and present days in annual for one by one each employee.
Sir excel 2007 me chal sakta hai kya
how i can adjust government holidays in this sheet ?
Bro main ne is sheet main uae holidays add karni hai. wo kase add kare gaye. Please ye bata do
I followed everything but it's not working.