GM. Sir. I have prepared this automated attendance register for students. Up to 2026. Iam very thankful to you. Now Iam subscribing your channel. Just now. Gn.
Sir Your teaching style is so good.I have been really very impressed by watching this video. I am very excited to watch the next video of this series about how can be saved and visible attendance of all employees when we needed by clicking on spin button of month and year. Thanks in advance.
Very Nice sir ji.. bahot acha laga.. please tell me if someone working on sunday too.. and over time and Half Day ka calculations bhi add kariye.... and ... month ending main salary calculatin bhi ho jae or total amount calculat ho jaye...
This is really a nice with you I really appreciate that you have taken a nice opportunity to resolve the query of many peoples my humble request is to provide the seat and we need Saturday Sunday off so kindly help with this Saturday Sunday conditional formatting
Thankyou very much Sir.....great sir Kindly make one more video.....how adjust A,B&C Shift automatically Automatic changes after off one week A and next Off after week B and third off after week C. (Aashish Gautom)
Fantastic, Sir, Can we create online bank reconciliation statement in excel which is connected our bank(s), & if any Debit ,Credit amount received in our bank, Our Excel sheet automatically update (reconcile). Please reply; My second question if we create any Payment voucher , Our entry ( Accounts Head ) automatically save in specific ledger. Is it possible??
Hi brother you are doing great job..... Thanks for great information.... I want to know how to prepare attendance forms for uniform service people who have 24 hrs job on and off and different shifts... can you please explain
Happy new year pravej sir , Next step bana dijye aage ka calculation data save kaise kiya jaye sab log wait kar rhe hai aap k next video ka to kosis kijye jaldi bana diya jaye taki sab k liye aachha ho jaye
Aap bahut Acha explain liye Bahut bahut shukriya. Mere ko ek doubt hai abhi samjho my example February me absent aur present add kiya march ka deta bhi wahi sheet me milega
Hello, Mr Parveez great teaching and really impressed with this video. And I would like to know for the payroll start dates and end dates ( 16 of Dec Willa be start date and 15 of Jan will be the end date)=30 days. Can you please help me with formula to find this
Very good work Sir Please can you make video how to creat a pos system in excel for small retail shop with invoice credit, cash ,day book monthely report ,Credit detail , customer detail , inventory.
Sir, please make a video jisme data b hr month me alag save kr pae nd previous month ka data save b ho jae automatically. (For future references) Thanks ☺
Excellence hai sir, please published a video containing multiple taxes calculation with the summary of taxes severally in invoice hope you will understand my point perhaps I am not able to conveyances I saw your many videos
Sir, I'm following regularly your Channel. It's very awesome and most useful to everybody. Could you make a data showing from EXCEL SHEET to TREEVIEW into the USERFORM? Kindly make it at your earliest.
kitna zydaa bdaaa bnaa diya tumne from 6:50 to 8:02 ye tumhe direct date lagaa ker bhi mil saktaa tha lekin nahi bemtlb ka itna lambaa khinch diya trust me dusre log kam time mai bhut achcha shikaa dete hai....
Hi DAWOOD, I need your help on the same kind of work. I need to highlight random but cinsecutive2 days week off for random 4 or 5 employee out of 20 every week. i have a ready sheet but i am unable to put in WeekOff in this way. can you really help?
Nice and really awesome...I made for my office mets to track the attendence sheet.but 1 discrepancy h ki month change krne p dates to proper change ho rhe h r sunday red m highlight ho rha h but present r absent ni change ho rha h wo same as it is hi rh rha h ...Can u tell me what is the problm
thank you ik or condition use ker sakty kya aap matlab jasy ap ny years or months ka bton bnaya kya asy humemployees k liye bana sakty k pory 12 month ki attandance ik employee k liye ik page per show ho jaye...thanks
Please complete the whole attendance sheet from Jan to dec as I would like to see how the change happens so that once the data saved in different months doesn't effect the sheet while doing the toggle between year and month...thank you
Hi Parvez, It is well designed sheet but I would want you to make attendance sheet for full year with user friendly buttons. Can you please prepare one send us link. It will be of great help
Sir as salam alikum sir apnay bohot acha bataya time sheet kay baray may. allaha ap khosh rakay. sir mara aik sawal hai kay hamara jo time sheet hai wo yanay 21-Dec-2018 say 20-Jan-2019 ka hai tu sir ais may kya formula use karo kay 21-Dec-2018 to 20-Jan-2019 show kay baga ka show nahi how. shokreya sir ap ka bhot bhot.
Hi thanks for the video, but also what is the next step to save the data as per the respective month, if you provide the video it will be a great help. Thanks
mai isse shift schedule ke liye use karna chahta hu to please mujhe batyenge mai day ke sath kaise assing shift ko fix kar lu taki month change ho to day bhi change hoga jisse mere shift fix hone ke karan nhi change hoga .please suggest me as soon as possible
Dear Sir thank you for Automatically Enter Off Day in Attendance Sheet in Excel VBA in Hindi step by step lesson in this video. If it is possible to write tick button on present and none on absent day then how can you do? if it is possible to make one then kindly show me some how. My name is Rana Jang Bahadur. Once again thank you to Daood Computer Centre. Happy New Year 2019.
Sir I Want to know how to save data date wise in the attendance sheet wise month wise. I make one VBA code it was transfer the data vertical but its not save date wise, please help me about of that.
Deepak ji, I have a 3thousand parts master list with part number & part name. On daily basis I make some entries out of these thousands of parts. I want I enter part number & automatically part name add in next row.
Mere excel sheet me four late coming me half day lagta hai 4 "L" means half salary cut aur 5/6/7 late coming me bhi half day ka hi amount dikhna chahiye but agar 8 late mark hote hai to 1 day salary ka amount ana chahiye multiple of 4 late mark half day ka salary cutna chahiye
Dear Sir, I work in transport company as per the transport business my drivers they don't have any specific off days its depends on the workload, Can please tell me what should i do i this case.
HI, Dear Parvez Brother - I am extremely proud of your contribution but I have a small glitch. My case is such that the attendance from the current month till the next month is calculated on the basis from 26th till 25th. With the above demonstration & being a complete newcomer, I am not able to calculate based on 26th as the starting date & ending on 25th. Kindly advise. I would be more than grateful to receive your precious guidance.
good day sir, sir i have a query that is " i made this attendance sheet but when i start to run it is giving an error with this message :"run time error '450' wrong number of arguments or invalid property assigenment. please resolve this so that i may do more practice
Very useful sir.Thanks a lot.Love you from Myanmar🇲🇲🇲🇲🇲🇲
GM. Sir.
I have prepared this automated attendance register for students. Up to 2026. Iam very thankful to you. Now Iam subscribing your channel. Just now. Gn.
Sir
Your teaching style is so good.I have been really very impressed by watching this video.
I am very excited to watch the next video of this series about how can be saved and visible
attendance of all employees when we needed by clicking on spin button of month and year.
Thanks in advance.
धन्यवाद सर जी बहुत ही अच्छी जानकारी मिली
Thanks for watching
Very Nice sir ji.. bahot acha laga.. please tell me if someone working on sunday too.. and over time and Half Day ka calculations bhi add kariye.... and ... month ending main salary calculatin bhi ho jae or total amount calculat ho jaye...
Very useful video. Kindly make it on full tutorial pls.
Aap ki video bhut helpfull hoti ha aap download link b dal diya kro
اسلام علیکم بہت خوب جناب
Yes, it's very useful and also tell how to go further for the attendance data...
Thanks for watching
This is really a nice with you I really appreciate that you have taken a nice opportunity to resolve the query of many peoples my humble request is to provide the seat and we need Saturday Sunday off so kindly help with this Saturday Sunday conditional formatting
Very nice sir, thankful to you for this training
kindly make a video for whole year and how to save data for previous month and year. Thanks a lot sir
So helpful.......... Thanks a lot...
Thanks for watching
Nice sir and thank u. .sir 1 baar iska design bata dijiye ki kaise design kiye h
Thanks for watching
Pivot table ka ek video banayega sir........ Jitna jaldi ho sake utna jaldi
Please sir continue further this series.....And thanks for this video
Parvez bro Good work mene apki takreeban sari videos dekhi hyn..... bohot acha kam kar rahe hyn ap... Love from Pakistan
Please describe further...
Thanks for such a useful tip
Bahot badhiya sirji
Sir, if Sunday is working ?
How to make attendance sheet on the same sheet / formate for 12 months or +
And please tell about over time calculations too..
Good JOB. Pls share almost video on VBA
Really Appreciable task. Awesome.
Thankyou very much Sir.....great sir
Kindly make one more video.....how adjust A,B&C Shift automatically
Automatic changes after off one week A and next Off after week B and third off after week C. (Aashish Gautom)
OK Aashish
Fantastic,
Sir, Can we create online bank reconciliation statement in excel which is connected our bank(s), & if any Debit ,Credit amount received in our bank, Our Excel sheet automatically update (reconcile). Please reply;
My second question if we create any Payment voucher , Our entry ( Accounts Head ) automatically save in specific ledger. Is it possible??
Hello Sheikh
Thanks for watching
its possible
explain in future video
+Daood Computer Centre OK sir , Iam waiting
Very Very Nice And Good Vedio 👍
Very very good. How to save different month n year database in it?
Hi brother you are doing great job..... Thanks for great information....
I want to know how to prepare attendance forms for uniform service people who have 24 hrs job on and off and different shifts... can you please explain
Happy new year pravej sir ,
Next step bana dijye aage ka calculation data save kaise kiya jaye sab log wait kar rhe hai aap k next video ka to kosis kijye jaldi bana diya jaye taki sab k liye aachha ho jaye
Thanks for Nice Teaching..!.
Just like this ... Can you please make a video of creating SHIFT ROSTERS ....
Good and useful one thank you.
Thanks for watching
Sir i said that I have problem this type, you made a video Thank you for it.
Thanks Aashish
Aap bahut Acha explain liye
Bahut bahut shukriya.
Mere ko ek doubt hai abhi samjho my example February me absent aur present add kiya march ka deta bhi wahi sheet me milega
Yup, Please upload the next video for,how to save data for future use?
OK
Thanks for watching
Sir.If you put every VBA formula in the description of the movie, then it is good because it will be easier for us people please sir
Hello, Mr Parveez great teaching and really impressed with this video. And I would like to know for the payroll start dates and end dates ( 16 of Dec Willa be start date and 15 of Jan will be the end date)=30 days. Can you please help me with formula to find this
THIS IS VERY VERY NICE SIR, PLEASE PUBLISH NEW SERIES OF THIS VIDEO LIKE ATTENDENCE SAVE AND VISIBLE IN FUTURE WITH PAST ATTENDENCE RECORD.
THANKS
Very good work Sir
Please can you make video how to creat a pos system in excel for small retail shop with invoice credit, cash ,day book monthely report ,Credit detail , customer detail , inventory.
Very good explanation
Sir, please make a video jisme data b hr month me alag save kr pae nd previous month ka data save b ho jae automatically. (For future references)
Thanks ☺
Ji mera v yahi sawal he
Excellence hai sir, please published a video containing multiple taxes calculation with the summary of taxes severally in invoice hope you will understand my point perhaps I am not able to conveyances I saw your many videos
Many many thanks to these topics
But one request plz
Can I get VBA code text format
Thanks for watching
Sir, very nice and Share Next Knowledge
sunday off ki if condition ke code ko for loop ke use se only 3 line ka code se bhi work ho sakta hai
Sir, I'm following regularly your Channel. It's very awesome and most useful to everybody. Could you make a data showing from EXCEL SHEET to TREEVIEW into the USERFORM? Kindly make it at your earliest.
Sir ek aisi vdo bno jisme hr Month ka data alg alg save ho aur pichhale month ka bhi record save ho
Apne kafi accha samjaya
Aise hi asan tarikese shift roster banaye jisme 1st or 2nd 3rd shift rotation me ani chahiye or weekly off bhi alag alag hone chahiye
Can we use for loop for change of columns instead of manually repeating the code
in vba sam line copy many time so can we define auto variable for short this formula?
Your video is osm.
Very useful video
Sir
I learn many formulas from this Video.
I need Separate Cell of
First Date & Last Date (Eomonth)
Thanks
How can I create a monthly timsheet with fixed weekly format monday to sunday. 1st of every month should auto fits into fixed weekly format?
You are a genius bro
Yes. Give full. Very nice
kitna zydaa bdaaa bnaa diya tumne from 6:50 to 8:02 ye tumhe direct date lagaa ker bhi mil saktaa tha lekin nahi bemtlb ka itna lambaa khinch diya trust me dusre log kam time mai bhut achcha shikaa dete hai....
does it possible to create formula for if 2 days off? i.e. sat & sun
Thanks for watching
Yes Its possible
Hi DAWOOD, I need your help on the same kind of work.
I need to highlight random but cinsecutive2 days week off for random 4 or 5 employee out of 20 every week. i have a ready sheet but i am unable to put in WeekOff in this way. can you really help?
Nice and really awesome...I made for my office mets to track the attendence sheet.but 1 discrepancy h ki month change krne p dates to proper change ho rhe h r sunday red m highlight ho rha h but present r absent ni change ho rha h wo same as it is hi rh rha h ...Can u tell me what is the problm
Nice
Sir jab bhi ap koi video banate hai neeche us video mein jo farmulas use hue hote hain unko type ker dya karen.
Thanks for watching
Aage se description me details diya karenge
thank you ik or condition use ker sakty kya aap matlab jasy ap ny years or months ka bton bnaya kya asy humemployees k liye bana sakty k pory 12 month ki attandance ik employee k liye ik page per show ho jaye...thanks
Please complete the whole attendance sheet from Jan to dec as I would like to see how the change happens so that once the data saved in different months doesn't effect the sheet while doing the toggle between year and month...thank you
hi can i make attendance sheet between two date like 26-jan-2022 to 25-feb-2022.is it possible please reply me
Yes it's possible
@@daoodcomputers sir please can u make the excel sheet which I told you.
I am very thankful to you sir
Sir es series ko aur sage btaye ki par month data save kaese hoga.
Hi Parvez,
It is well designed sheet but I would want you to make attendance sheet for full year with user friendly buttons. Can you please prepare one send us link. It will be of great help
Thanks
Please complete video with data filling
बहुत खूब
DETA NOT SAVE the WRONG SHEET IF DETA SAVE THEN IT IS VERY GOOD SHEET BROTHER
Sir as salam alikum
sir apnay bohot acha bataya time sheet kay baray may. allaha ap khosh rakay. sir mara aik sawal hai kay hamara jo time sheet hai wo yanay 21-Dec-2018 say 20-Jan-2019 ka hai tu sir ais may kya formula use karo kay 21-Dec-2018 to 20-Jan-2019 show kay baga ka show nahi how.
shokreya sir ap ka bhot bhot.
FROM TODAY YOU ARE MY EXCEL GURU
Can we pull data from sql in this sheet ?
Hi thanks for the video, but also what is the next step to save the data as per the respective month, if you provide the video it will be a great help. Thanks
Thanks for watching
Next Video for payroll accounting software coming soon
mai isse shift schedule ke liye use karna chahta hu to please mujhe batyenge mai day ke sath kaise assing shift ko fix kar lu taki month change ho to day bhi change hoga jisse mere shift fix hone ke karan nhi change hoga .please suggest me as soon as possible
Iska ek yesa vidio bnao si Jo ek hi bar me poori jankari mil jaye
Could it be run in Excell 2016 ??
Better teaching sir in advance label learn more about computer in Excel
Kya hum OFF vala column merge kar sakte hai...??
Nahi
hai if ours is shift duty ,if w.off changes for each on different days how to do ,please explain
Dear Sir thank you for Automatically Enter Off Day in Attendance Sheet in Excel VBA in Hindi step by step lesson in this video. If it is possible to write tick button on present and none on absent day then how can you do? if it is possible to make one then kindly show me some how. My name is Rana Jang Bahadur. Once again thank you to Daood Computer Centre. Happy New Year 2019.
Coding se achha aur easy way to if formula se ho jayega jinhe p dikhana h wo p honjayega aur jinhe rest dikhana h wo rest ho jayega yani off.
Sir I Want to know how to save data date wise in the attendance sheet wise month wise. I make one VBA code it was transfer the data vertical but its not save date wise, please help me about of that.
Excellent...
Hi this is good but hove to save last month data in attendance register so request share the Video for all data saving in this sheet i have required
Thanks for watching
Payroll Software video coming Soon
thanks for your video.
Your video is amazing. But I want to automatically register "P" in other empty columns.
excellent job
thank you usttad
Thanks for watching
Nice tutorial
Is file ko excel macro enabled template format me save karenge?
Sir mujhe a,b,c automatic shift schedule for 1 year aur weekly rest alag2 days k liye formule ki jankari chahiye thi...
Sir I want to next video save all months attandance
Hello Daood Computer Centre,
If employee has different day off how can we make the VBA code please.
Nice video...sir
Deepak ji, I have a 3thousand parts master list with part number & part name. On daily basis I make some entries out of these thousands of parts. I want I enter part number & automatically part name add in next row.
Hi Brijesh
This is Daood Computer Centre
Mere excel sheet me four late coming me half day lagta hai 4 "L" means half salary cut aur 5/6/7 late coming me bhi half day ka hi amount dikhna chahiye but agar 8 late mark hote hai to 1 day salary ka amount ana chahiye multiple of 4 late mark half day ka salary cutna chahiye
Dear Sir, I work in transport company as per the transport business my drivers they don't have any specific off days its depends on the workload, Can please tell me what should i do i this case.
Thanks for watchingWatch my latest videoEmployee / Student userform with phototh-cam.com/video/Lq-UTNurhFc/w-d-xo.html&lc=UgzDOQbaXTDYZOdNH8B4AaABAg
HI, Dear Parvez Brother - I am extremely proud of your contribution but I have a small glitch. My case is such that the attendance from the current month till the next month is calculated on the basis from 26th till 25th. With the above demonstration & being a complete newcomer, I am not able to calculate based on 26th as the starting date & ending on 25th. Kindly advise. I would be more than grateful to receive your precious guidance.
Sir please tell me solution jaise ki febuary me persent ki entry ki or month change Kiya to wahi entry March me show Hoti Hai
Sir in my attendance sheet start from 16/1/2018 to 15/2/2018 and some staff having weekly off on sun and Monday like can you do that attendance sheet
Sir, single work sheets has 30 up pages could you have any solution to control data like attendanc every page by spin botton.
good day sir, sir i have a query that is " i made this attendance sheet but when i start to run it is giving an error with this message :"run time error '450'
wrong number of arguments or invalid property assigenment. please resolve this so that i may do more practice