Automatically Enter Off Day in Attendance Sheet in Excel VBA Step by step

[@entertainmentsmm]

Very useful sir.Thanks a lot.Love you from Myanmar🇲🇲🇲🇲🇲🇲

[@akdpkd]

धन्यवाद सर जी बहुत ही अच्छी जानकारी मिली

[@daoodcomputers]

Thanks for watching

[@trivedikumarsonesh4194]

Very Very Nice And Good Vedio 👍

[@pankajhiralalpatel4454]

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.

[@TECHLIFEtechlife]

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.

[@AdirSingh]

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...

[@heeralalkumar5904]

Very useful video

[@SanviPatil2019]

Bahot badhiya sirji

[@mirzafahad5853]

Very useful video. Kindly make it on full tutorial pls.

[@soumennath238]

Yes. Give full. Very nice

[@rajapatelabdulhai6829]

اسلام علیکم بہت خوب جناب

[@ashikfoysal4172]

So helpful.......... Thanks a lot...

[@daoodcomputers]

Thanks for watching

[@babubaacha]

Yes, it's very useful and also tell how to go further for the attendance data...

[@daoodcomputers]

Thanks for watching

[@mamoied]

Very good explanation

[@kunjansingh9475]

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

[@RajVeer-xn1jj]

Aap ki video bhut helpfull hoti ha aap download link b dal diya kro

[@NikhilKumar-vr9yy]

Apne kafi accha samjaya

[@RahulSharma-oj4li]

Please sir continue further this series.....And thanks for this video

[@bestonlinegk3998]

बहुत खूब

[@panku12101]

Really Appreciable task. Awesome.

[@mansoorahmed2484]

Thanks for Nice Teaching..!.

[@atulkumarvaishya2062]

Your video is osm.

[@jyotikantadas9149]

Please describe further... Thanks for such a useful tip

[@Princeopislive]

Parvez bro Good work mene apki takreeban sari videos dekhi hyn..... bohot acha kam kar rahe hyn ap... Love from Pakistan

[@ManiCreativeArts]

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

[@aashishgautom3785]

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)

[@daoodcomputers]

OK Aashish

[@PawanKumar-sk8tj]

Sir, very nice and Share Next Knowledge

[@gungurung36]

Good and useful one thank you.

[@daoodcomputers]

Thanks for watching

[@jidanmahmud142]

You are a genius bro

[@dharmendrakumarsharma1048]

Good JOB. Pls share almost video on VBA

[@aashishgautom3785]

Sir i said that I have problem this type, you made a video Thank you for it.

[@daoodcomputers]

Thanks Aashish

[@suvendusingha2]

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

[@futuretechnology6896]

Yup, Please upload the next video for,how to save data for future use?

[@daoodcomputers]

OK Thanks for watching

[@prag300585]

Very very good. How to save different month n year database in it?

[@merajrxl]

Nice sir and thank u. .sir 1 baar iska design bata dijiye ki kaise design kiye h

[@daoodcomputers]

Thanks for watching

[@adityavyas594]

Just like this ... Can you please make a video of creating SHIFT ROSTERS ....

[@alokmishra5266]

Very nice vedio

[@saptarshiguin3117]

FROM TODAY YOU ARE MY EXCEL GURU

[@sampatjangid5410]

Pivot table ka ek video banayega sir........ Jitna jaldi ho sake utna jaldi

[@sabeelmughal1]

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.

[@chandanarya1784]

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

[@sajjadanjum2302]

Sir I learn many formulas from this Video. I need Separate Cell of First Date & Last Date (Eomonth) Thanks

[@prasadmj907]

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

[@banglatechhotspot2235]

Nice tutorial

[@yousefgo7603]

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

[@mgpkumar9190]

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.

[@tushardomale5911]

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

[@coolag74]

Excellent...

[@NikhilKumar-vr9yy]

Very good

[@vishalwatts]

thank you usttad

[@daoodcomputers]

Thanks for watching

[@learnwithmk5531]

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

[@zahirkhan6329]

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

[@nassirmuhammadrafique8752]

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

[@hanifsaiful0075]

excellent job

[@jituydav]

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 ☺

[@RizwanAnsari-kv6yb]

Ji mera v yahi sawal he

[@rajeshuikey9864]

Nice video...sir

[@dilipyadav5474]

Iska ek yesa vidio bnao si Jo ek hi bar me poori jankari mil jaye

[@PAKBOOKKEEPINGSERVICES]

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??

[@daoodcomputers]

Hello Sheikh Thanks for watching its possible explain in future video

[@PAKBOOKKEEPINGSERVICES]

+Daood Computer Centre OK sir , Iam waiting

[@alisheikh3670]

V nyc

[@RajuGupta-ic3ho]

Better teaching sir in advance label learn more about computer in Excel

[@RafiqKhan-xp2ic]

Mashallah very good

[@sushilyadav5805]

Sir ek aisi vdo bno jisme hr Month ka data alg alg save ho aur pichhale month ka bhi record save ho

[@cgtech2991]

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

[@nsudarji143]

Thanks Please complete video with data filling

[@Mechnicalwork]

DETA NOT SAVE the WRONG SHEET IF DETA SAVE THEN IT IS VERY GOOD SHEET BROTHER

[@dksknowledgeforkids1726]

I am very thankful to you sir Sir es series ko aur sage btaye ki par month data save kaese hoga.

[@kunal_YT_007]

Thanks sir

[@syedmahamoodashrafi3434]

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

[@sharunsaifi9075]

Sir, if Sunday is working ? How to make attendance sheet on the same sheet / formate for 12 months or +

[@AdirSingh]

And please tell about over time calculations too..

[@mohammadnoman5560]

Wonderful

[@daoodcomputers]

Thanks for watching Watch my latest videoEmployee / Student userform with photo kzbin.info/www/bejne/gqKQhoeEqtebfMU&lc=UgzDOQbaXTDYZOdNH8B4AaABAg

[@Sajjadgouri786]

sunday off ki if condition ke code ko for loop ke use se only 3 line ka code se bhi work ho sakta hai

[@DeepakKumar-vc3fz]

Very helpful

[@daoodcomputers]

Thanks Deepak

[@easylife1917]

Many many thanks to these topics But one request plz Can I get VBA code text format

[@daoodcomputers]

Thanks for watching

[@railtechecr592]

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.

[@drvinodkm]

thank u sir ji

[@jouher100]

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....

[@rakeshdas-dw5fd]

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

[@himanshugupta6915]

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

[@subramanyamcr3532]

Excellent

[@daoodcomputers]

Thanks for watching

[@laxmanraju2688]

GREAT

[@daoodcomputers]

Thanks for watching

[@MrRicks30]

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?

[@khawajarizwan7006]

thats good

[@kumarsharmaajit4811]

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?

[@RajeshKumar-su6ei]

Nice Sir

[@dharmendrasinha2486]

thanks

[@PawanKumar-ww6uf]

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

[@praveenmarwaha3653]

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

[@shabadinsan5785]

I needed the full series of this sheet

[@ramkumarprajapati8793]

Sir I want to next video save all months attandance

[@Grandkidsmovies]

Awsome

[@atiflatifsatti854]

Plz send next series of attendance management

[@9913961356]

Sir we are waiting second part

[@kasim617]

does it possible to create formula for if 2 days off? i.e. sat & sun

[@daoodcomputers]

Thanks for watching Yes Its possible

[@rssbshabad646]

Can we use for loop for change of columns instead of manually repeating the code

[@ashishmalik8705]

Sir mujhe a,b,c automatic shift schedule for 1 year aur weekly rest alag2 days k liye formule ki jankari chahiye thi...

[@9922489092]

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

[@dhruvmistry9580]

Sir bohot helpful he lekin jese hi dusra mahine select karta hu me spinner se to pichle mahine me jo data enter kiya vo hat jata he uska kya karu?

[@Ali-vr9se]

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

[@daoodcomputers]

Thanks for watching Payroll Software video coming Soon

[@nasirkhan-vb7ym]

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.

[@makaniharesh1459]

Kya hum OFF vala column merge kar sakte hai...??

[@daoodcomputers]

Nahi