@@vbAFun Dear Sir I want you to please customize this program as per our requirements. If it is OK with you, then I will share our sheet of attendance for your understanding please. Regards.
Sir बहुत ही बढ़िया शिखते है आप। मुझे Sir आपसे एक चीज शिखनी थी की अगर मेरे पास Multipal Workbook हो उसमे Data same हैं लेकिन उसका Column Header Change हो गया है। उसे मुझे New Workbook में Merge करना है Column Header के हिसाब से तो Sir ये Posible हैं। अगर हो तो Sir बताएगा कैसे होता है। Please 🙏
Hi Good Evening Sir, Thank you very much for your tutorial. but it is not working dynamically., please can you release another video in the ner future.
Sir, Agar saturday & Moday Leave hai to Sunday ko leave A Display ho aur total leave calculate ho .. vba code kaisa hoga o samja nahi . main try karke dekha par nahi jam raha please bataye
No issue you have asked any question, i will reply you with answer if I know. You just need to add a new workbook by writting workbook.add command then set that book in name then export as you copy one sheet to other sheet
Good one sir Annual Leave Kaise Add kar sakte hai sir Abhi isme contusions leave add karna hai tho example employee ne 1 Jan se 3 Jan tak leave liya tho 3 times add karna pad raha hai Koi solution hai tho uska video banao sir Thank you in advance
@@vbAFun i mean create tool in such way, you can mark attendance on daily basis which will upload into ms access database and create one more Excel to extract the attendance data from database as per requirement for example you can extract it monthly, year summary
सर मुझे सब्जेक्ट वाइज अटेंडेंस बनाना है यूनिवर्सिटी में जॉब् करता हु 🙏 1 दिन में पांच क्लास होती हैं। अगर स्टूडेंट 5 पांचों के सब्जेक्ट में प्रजेंट लगा दूंगा , मगर शीट 1 हि होना चाहिए , और उसका परसेंटेज अटेंडन्स का मालूम भी चले सेलेरी की जगह पर % of अटेंडन्स निकलना हैं हर बच्चे का
Sir abhi ek video dekha , bahut achchha h par sheet par kya kar rahe hain kuch nazar nahi aata ,camera focus chahiye taaki sahi se nazar aa sake . Please phone me jyada enlarge nahi kar sakte hamen fayada tabhi hoga jab theek se dekh saken. Sir ye mera apna vichar h ho sakta h aur log theek dekh pa rahe ho .
I am very sorry ki apko trouble hua, maine video banane ke bad ise aur bhi inlarge karne ka koshish Kiya agar uske bad bhi problem hai to mai koshi Karu ga agle. Ideo se ise aur bhi asche aur enlarge karke banau. Thank you for your like and share
Sir 3 din Se paresaan hu Present Status Lag hi Nai raha hai bug aa ja raha hai Sub PresentStatus() Sheet5.Range("A1:D" & Rows.Count).AdvancedFilter xlFilterCopy, Sheet5.Range("H1:H2"), Sheet5.Range("J1:M1"), False
But I want to create a form of measurement unit converter of weight, length, electricity and many more. Plz create this application. Plz, plz, plz 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
@@vbAFun Sir bank ma lot of customers hote ha .bank statement Lene per debit or credit & balance or opening balance show hota ha . kindly Aasa userform apload kare.
Sir, Good Morning, Automatic Attendance Register Project bahut Assume hai. isme kam kar rahe the but advance filter function kam nahi kar raha hai Q ? Please rpl me............. 🙏🙏🙏🙏🙏
और अटेंडेंस फ्रॉम डेट से टू डेट निकालना है 3 महीने का अटेंडन्स जाता हैं। स्टडेंट के गार्जन को रिपोर्ट भेजना होता है मेजिन या तिमाहि अटेंडेन्स कैंसे दंगे मार्गदर्शन करें sir जय हिन्द सर
Apke kam ke liye mujhe detail me ap abhi tak kaise karte aa rahe hai use samajhna hoga uske bad hi ispe kam ho sakta hai aap mujhe insta ya Facebook me contact kare
Apki hr new video shiddat se intzaar krta hoon.
Kindly ya school ka software bnana sikha dain ya Medical store ka
Awesome Sir. I want to customize the same as per our requirements. Can it be done Sir.
Yes you can do as per your requirement
@@vbAFun Dear Sir I want you to please customize this program as per our requirements. If it is OK with you, then I will share our sheet of attendance for your understanding please. Regards.
How I can parchase school management system
You can contact me on instagram after discussion will make the application as per your requirement
Excellent. Sir, is me salary add kardenge to or bhi acha hoga.
Yes salary bhi add ho jayega video bahut lamba ho gaya tha isliye ise chhodna pada
Very infomative video
can we change the year like month without typing year manually plus having many years in one workbook
let me know
thanks
Yes you can
Sir aapka profit and loss software bahut usefull he but usme aur zyada features rhega to bahut acha hota
Thank you for your support. Aur kya features dene chahiye
Sir बहुत ही बढ़िया शिखते है आप।
मुझे Sir आपसे एक चीज शिखनी थी की अगर मेरे पास Multipal Workbook हो उसमे Data same हैं लेकिन उसका Column Header Change हो गया है। उसे मुझे New Workbook में Merge करना है Column Header के हिसाब से तो Sir ये Posible हैं।
अगर हो तो Sir बताएगा कैसे होता है।
Please 🙏
Agar column no atleast same ho to go sakta hai
Excellent sirji
Thank you
Good nice project sir
Thank you for your support
Hi Good Evening Sir,
Thank you very much for your tutorial. but it is not working dynamically., please can you release another video in the ner future.
Ok I will try
Sir, Agar saturday & Moday Leave hai to Sunday ko leave A Display ho aur total leave calculate ho .. vba code kaisa hoga o samja nahi . main try karke dekha par nahi jam raha please bataye
Thnks.. Waiting for long time
Thanks watch full video and comment with your feedback
Sorry I have also Question today 🙋♂️
How export data in new workbook...
Without headings
Means sheet mesy data cut kr k new workbook me add krna ho
No issue you have asked any question, i will reply you with answer if I know.
You just need to add a new workbook by writting workbook.add command then set that book in name then export as you copy one sheet to other sheet
@@vbAFun thanks
Thanks Sir
Awesome sir
Thank you for your support
Good one sir
Annual Leave Kaise Add kar sakte hai sir
Abhi isme contusions leave add karna hai tho example employee ne 1 Jan se 3 Jan tak leave liya tho 3 times add karna pad raha hai
Koi solution hai tho uska video banao sir
Thank you in advance
Yes uska solution hai ise hame net video me bataye GE kaise aap ek sath add kar sakte hai
Awesome Sir Ji, upload this data to database ms access and create one more Excel file for extract the data from ms access
I don't get you can you explain some more
@@vbAFun i mean create tool in such way, you can mark attendance on daily basis which will upload into ms access database and create one more Excel to extract the attendance data from database as per requirement for example you can extract it monthly, year summary
Okay
SUPER SIR,PLEASE GIVE ME MODULES COPY ! THANKS FOR YOU
Sir aap school fees management software banayeye plz sir mail bahut jyade din se es video Ka wait or raha hu.
Aap ek bar khud se banane ka koshis kijiye jarura banega usme agar koi help chahiye to aap membership join karke live support le sakte hain
Sir html and php se daybook banake upload kijiye na sir ham kahi bi jake web me operate kre jaisa
I am very sorry kyuki Mai php ya html nahi janta
सर मुझे सब्जेक्ट वाइज अटेंडेंस बनाना है यूनिवर्सिटी में जॉब् करता हु 🙏 1 दिन में पांच क्लास होती हैं। अगर स्टूडेंट 5 पांचों के सब्जेक्ट में प्रजेंट लगा दूंगा , मगर शीट 1 हि होना चाहिए , और उसका परसेंटेज अटेंडन्स का मालूम भी चले सेलेरी की जगह पर % of अटेंडन्स निकलना हैं हर बच्चे का
Sir abhi ek video dekha , bahut achchha h par sheet par kya kar rahe hain kuch nazar nahi aata ,camera focus chahiye taaki sahi se nazar aa sake . Please phone me jyada enlarge nahi kar sakte hamen fayada tabhi hoga jab theek se dekh saken. Sir ye mera apna vichar h ho sakta h aur log theek dekh pa rahe ho .
I am very sorry ki apko trouble hua, maine video banane ke bad ise aur bhi inlarge karne ka koshish Kiya agar uske bad bhi problem hai to mai koshi Karu ga agle. Ideo se ise aur bhi asche aur enlarge karke banau.
Thank you for your like and share
I am very thankful to you sir for replying .
Thank you for your support
Sir 3 din Se paresaan hu Present Status Lag hi Nai raha hai bug aa ja raha hai
Sub PresentStatus()
Sheet5.Range("A1:D" & Rows.Count).AdvancedFilter xlFilterCopy, Sheet5.Range("H1:H2"), Sheet5.Range("J1:M1"), False
Dekhiye aap video ko dekh ke uska concept samjhiye fir use application me apply kijiye isse aap bhi badi asani se Sikh sakte hai coding ka
Class de sakte hai sir
Yes nighte 8 se 9 on zoom par karte hai
Sir, please make multiple shift staff roster 24*7
Ajay bhai plz make an application of all measurement unit converter in excel. Plz plz, plz.
Plz give me reply.
I need it (converter) quickly.
🙏🙏🙏🙏🙏🙏🙏
This is sple mathematics calculation you can easily create in excel just download all calculation from Google and set in your Excel
But I want to create a form of measurement unit converter of weight, length, electricity and many more. Plz create this application. Plz, plz, plz
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Sir please video upload how to customer ledgers debit credit & balance amount .I have to request please
Like can you show me some example on instagram
@@vbAFun Sir please upload in userform Sir please once again.
Maine kaha ki kis tarah aap chah rahe ho
@@vbAFun Sir lot of customers in sheet we have search on next sheet one customer debit & credit & show balance amount.
@@vbAFun Sir bank ma lot of customers hote ha .bank statement Lene per debit or credit & balance or opening balance show hota ha . kindly
Aasa userform apload kare.
Sir 10-12 Day leave Kaisa dale
Sir code download link please
Please check description
Sir ek employee ka 5 off kaise dale
Upload on daily basis
What upload you want daily ?
Sir,
Good Morning,
Automatic Attendance Register Project bahut Assume hai. isme kam kar rahe the but advance filter function kam nahi kar raha hai Q ?
Please rpl me............. 🙏🙏🙏🙏🙏
Dekhiye ye advance filter ke code ko step by step dekhiye ki kaha pe error hai
Error kuch bhi nahi dekha raha hai or excel me bhi kuch out put show nahi ho raha hai.
Aap one by one code ko run karke dekhiye
F8 press kar ke dekh liye nahi kuch bhi nahi out put ata hai
Aise to pata nahi chalega ki problem kya hai
और अटेंडेंस फ्रॉम डेट से टू डेट निकालना है 3 महीने का अटेंडन्स जाता हैं। स्टडेंट के गार्जन को रिपोर्ट भेजना होता है मेजिन या तिमाहि अटेंडेन्स कैंसे दंगे मार्गदर्शन करें sir जय हिन्द सर
Apke kam ke liye mujhe detail me ap abhi tak kaise karte aa rahe hai use samajhna hoga uske bad hi ispe kam ho sakta hai aap mujhe insta ya Facebook me contact kare
Sir Absent Show and Haff Day Nahi Show Kar raha hai
Apko isme leave ke sheet me Jake date dalna hoga please check kare
Hsmara holiday friday hu
To condition me 7 ke jagah 6 likhe
Sir code error bata raha ha
Run Time Error '1004' aa raha hai
Sir please profit & loss excel file link attachment UTube.
I have given the code link in description please try to make and add the code
@@vbAFun I have to humble request Sir
Okay wait i will update the link tomorrow please
@@vbAFun lot of Thanks
Kindly VBA CODE UPLOAD
Practice file not working
sir quality only 240 hai
Nahi Aisa nahi hona chahiye please check again hd me maine video ko banaya hai ho sakta hai RUclips ne hd me processing nahi kiya ho
Yes, RUclips balo ne abhi tak HD me ise process nahi kiya hai abhi tak ise process hi kar raha hai. Please watch after some time again.
helllllllllllllllllllp sir
P & A Not Fill
Please check kijiye leave ka date apne sahi dala hai ya nahi
Sub GenAttendance()
AttLastRow = Sheet1.Range("D" & Rows.Count).End(xlUp).Row
If AttLastRow > 7 Then Sheet1.Range(8 & ":" & AttLastRow).EntireRow.Delete
stdt = Sheet1.Range("F7")
Eddt = Sheet1.Range("E5")
LASTROW = Sheet3.Range("A" & Rows.Count).End(xlUp).Row
attrow = 8
For Emprow = 2 To LASTROW
If Sheet3.Range("D" & Emprow) = stdt) Then
Sheet1.Range("D" & Attraw) = Sheet3.Range("A" & Emprow)
Sheet1.Range("E" & Attraw) = Sheet3.Range("B" & Emprow)
attrow = attrow + 1
End If
Next Emprow
End Sub
not work
❤❤❤❤❤