sir how r u. i prepare automatic data entry form in excel according in the light of your video and successfully run but on next when I work on this form. there is problem in saving data and message is shown that macro is not properly work. sir please explain about this problem.......
Very nice sir it is wonderful to see this kind of creativity. Only question when we are assingning the macros to the linked pictures, macros still active even in the greyed pictures not even green so please suggest any step to avoid blank entry in the database. Basically macros assign karne k baad bhi him us pic per click karte h to blank entry hoti h. Thanks for sharing Happy Leaning
Sir, u explaind in short and easy way, the last step, assign macro, I m using window 7 professional i am not getting assign micro when right click on submit or clear pls suggest other option to assign
sir, hum aapka video bahut dekhte hain aur bahut kuch sikhe hain aapke video se. sir, aap bakai mein jabardast hain. Sir, ek sawaal puchna tha aapse, waha yaha ki jab tak submit button highlight nahi hota hai tabtak submit nahi hota hai data, yaha toh humne jaan liya lekin jab submit button highlight hone se pehle bhi hum jab us jagah mein click karte hain toh bhi data submit ho jata hai. iska kuch upai bataiye ki jab tak term & condition button na dabaye tabtak submit button bhi deactive rahe. pls. sir bataiye.
Bro mujhe database mai jo data save hota hai woh serf 1 hota hai aur agr new entry save kr toh bhi phela wala k sath replace hota hai database sheet woh kyun hota hai... plz reply fast....
hello sir greetings and thank you for the outstanding explanation; however i have a question what will happen after we press submit? all the info where do they go? to the website of the college or to a specific source?/
dear sir i am from pakistan i want to make data entry from like you make for my workers on a different sheet. like when i entry date it should go to different sheet according to their name. can u please help me in this regard i will be very thankful to you sir please reply
How can we fill student data in the certificate automatically by using admission number only? For example i have a database where each student has unique admission number, now i want to print school leaving certificate and want to fill student name, father's name etc in the certificate by using admission number only? plz make a video on this topic
Respected sir With warm regards, I have result sheet of class xi with many subjects. I want to make a marksheet individual against particular registration number selecting subjects from drop-down list.
Sir ji office 365 me Get Data ka option nahi Aaraha hai कैसे laye, or usme query options nahi a rahe hai, jaise मैं Get Data phir files or folders ko pdf ko lana chahte hai tab मुझे प्रॉब्लम हो रहा है?
maay ye chata hoo kaay jab data base maay entry shift hoo jaay to data base wali sheet hide ho jaaay. database wali sheet ko koii see na kersakaaay....
SIR MAINE 5 ENTERIES KI HAI OR GALAT HONE K KARAN PHIR DATA SHEET SE USKO DELETE KAR DIYA HAI, AGAR MAIN DATA SHEET SE KOI ENTRY DELETE KARTA HOON TO NEXT ENTRY 6 ROW SE HI START HOTI HAI . ISKO ERASE KARKE PEHLI ROW SE HI ENTRY KARNI HO TO KYA KARNA HAI?
macro record ke dauran aapne unko delete kar diya hoga, jahan formula laga hai un cells ko delete nahi karna hai, sirf unko delete karna hai jinme manual entry karte hain
@@ComputerGyanGuruji20:40 par jin cell ko aapne copy ki unhi cell ko me bhi copy kar rha hu. But macro run hone ke bad upar ke form ki entry cell ko niche jo = wale formule se link kiya tha vo hat ja rhe he.fir bad me upar form me entry karne par vo data niche ki sheet par show nhi ho rhe he puri sheet blank hi ho rhi he .mene 5 6 bar formula laga kar aur macro run kar ke dekha he plz solution batayiye
Sir, Data entry form में data feed करते समय mouse का इस्तेमाल करने से form को design करने का महत्व की ख़त्म हो जाता है, मै चाहता हूं कि जो form हमने बनाया है उसमें tab button से एंट्री cell में cursor अपने आप चला जाए, कैसे करे
Cell lock karke ham aisa kar sakte hain iske liye bhi hamne bataya hai, jin cell me entry karni hai unko chhod kar baki puri sheet ko protect kar dene se aapki samasya hal ho jayegi
इसमें कंपलीट एंट्री कर सबमिट करने पर एंट्री डेटाबेस में ट्रांसफर होने के बाद दुबारा खाली फॉर्म को सबमिट करें तो खाली फॉर्म की एंट्री भी हो रही है इसको कैसे रोके
Great video, I have have small business need to make data entry format in excel tried but did not able, can u help. In. This give ur mail id I'll send my detail quarries
Sir best knowledge guru hai aap 🙏
Really great sir, it's very amazing.. I learnt many new thinga here...🙃 Thank you so much sir.
You are great teacher, Sir. Thanks sir
Nice and thnx sir it is most useful ❤❤❤❤
ITS VERY USEFUL SIR . ME FROM NEPAL
Very nicely explained.. 👍
Bhai apka shukriya apse vba seekh Raha hu bhot acha hai fully automatic data entry form mein search aur add button bhi banana sekha do please
Learning from starting
Good work.
Very informative video
Sir, well explained
Great sir
sir how r u. i prepare automatic data entry form in excel according in the light of your video and successfully run but on next when I work on this form. there is problem in saving data and message is shown that macro is not properly work. sir please explain about this problem.......
Print ka option bhi batayiye isi me submit k bad
बेहतरीन
sir hum isme photo bhi add ker sakte h kya
Very nice video G gbu sir g sir agar ghar per data entry ka work karna ho ta kasia kara
Hi sir good morning,
बहुत सुंदर प्रेजेंटेशनहै साथ ही बहुत उपयोगी भी है धन्यवाद,
स्टूडेंट इनफॉरमेशन के डाटा एडिट करना है तो क्या करना पड़ेगा प्लीज बताईए
Very nice sir it is wonderful to see this kind of creativity.
Only question when we are assingning the macros to the linked pictures, macros still active even in the greyed pictures not even green so please suggest any step to avoid blank entry in the database.
Basically macros assign karne k baad bhi him us pic per click karte h to blank entry hoti h. Thanks for sharing Happy Leaning
Sir, u explaind in short and easy way, the last step, assign macro, I m using window 7 professional i am not getting assign micro when right click on submit or clear pls suggest other option to assign
गजब
hi, good n clear...how i add search if so many entries, how i add print opp or share opp if i use as invoice or rcpt
When i entered submit its not saving old is deleted and its saving
hi Sir, can you explain how to delete multi-select itmes from the listbox as well as from sheet (Using userform). Thanks
Please also make video in google sheet for this form
needs to generate one pdf from various sheets and these sheets also need certain details to be filled by user
sir, hum aapka video bahut dekhte hain aur bahut kuch sikhe hain aapke video se. sir, aap bakai mein jabardast hain. Sir, ek sawaal puchna tha aapse, waha yaha ki jab tak submit button highlight nahi hota hai tabtak submit nahi hota hai data, yaha toh humne jaan liya lekin jab submit button highlight hone se pehle bhi hum jab us jagah mein click karte hain toh bhi data submit ho jata hai. iska kuch upai bataiye ki jab tak term & condition button na dabaye tabtak submit button bhi deactive rahe. pls. sir bataiye.
Dhanyawad
Bro mujhe database mai jo data save hota hai woh serf 1 hota hai aur agr new entry save kr toh bhi phela wala k sath replace hota hai database sheet woh kyun hota hai... plz reply fast....
Sir same thing can be possible in Google Sheet?
Kya is ko print kr sakty hain kya
And har use ke liye alg form bnana pdta hai ais koi form ho jis me bhut sare user same time pe entry kr saken like html form
I need this most likely software
Please sir make a Gst invoice with record data in excel
Thanks u pls sens attendance sheet during two month
daynimc form ban sakta hai kya sir
Sir ye bhut accha hai but ye mobile se submit nhi hota
hello sir greetings and thank you for the outstanding explanation; however i have a question what will happen after we press submit? all the info where do they go? to the website of the college or to a specific source?/
dear sir i am from pakistan i want to make data entry from like you make for my workers on a different sheet. like when i entry date it should go to different sheet according to their name. can u please help me in this regard i will be very thankful to you sir please reply
Sir .. How to use Tab or Enter switch ?
Why not working Tab switch (next entry),if possible how to use ?
Why we can't go directly on first cell when macro recording is on
Sir agar ek hi cell me mulple detail dalni ho jaise uske paas 5 bank account hai aur pacho dikhane ho to kaise dikhaye
I want to emmendment or remove in save entry to called and correction
Possible
Decfine
Sir,Sheet ki download link bhi diya kare
Sir iss me time stamp ke sath bnaoo
Someone please tell me k inho ne ek ek cell ko kese select kiya i mean multiple cell" ko ek bar main kese
Sir reg no automatic save karna ho to
Sir yeh kis format mein save hogi file
Normal save par links auto delete ho ja rahe h
HI SIR, How to make online Attendence system by Google form All classes 1st to 10th if you have any video link please share me.
Mujhy daily or monthly production report from Bana hy is KY ly ap help kar sakty ho
How can we fill student data in the certificate automatically by using admission number only?
For example i have a database where each student has unique admission number, now i want to print school leaving certificate and want to fill student name, father's name etc in the certificate by using admission number only? plz make a video on this topic
Sir mujhe bhi chihye
I got everything but only one fault. How to use only tab
Respected sir
With warm regards, I have result sheet of class xi with many subjects. I want to make a marksheet individual against particular registration number selecting subjects from drop-down list.
Sir ji office 365 me Get Data ka option nahi Aaraha hai कैसे laye, or usme query options nahi a rahe hai, jaise मैं Get Data phir files or folders ko pdf ko lana chahte hai tab मुझे प्रॉब्लम हो रहा है?
my workers use to do over time on monthly basis i can send you a format if you want
There are a problem faced when I am making this sheet. The problem is 1 came with this √1.plz tell me how will solve this problem....
maay ye chata hoo kaay jab data base maay entry shift hoo jaay to data base wali sheet hide ho jaaay. database wali sheet ko koii see na kersakaaay....
photo add korke full video dijiye
SIR MAINE 5 ENTERIES KI HAI OR GALAT HONE K KARAN PHIR DATA SHEET SE USKO DELETE KAR DIYA HAI, AGAR MAIN DATA SHEET SE KOI ENTRY DELETE KARTA HOON TO NEXT ENTRY 6 ROW SE HI START HOTI HAI . ISKO ERASE KARKE PEHLI ROW SE HI ENTRY KARNI HO TO KYA KARNA HAI?
Micro1 run karne ke bad niche ki sheet me jo = karke entry link ki thi vo sare formula hat jate he kya karna hoga
macro record ke dauran aapne unko delete kar diya hoga, jahan formula laga hai un cells ko delete nahi karna hai, sirf unko delete karna hai jinme manual entry karte hain
@@ComputerGyanGuruji20:40 par jin cell ko aapne copy ki unhi cell ko me bhi copy kar rha hu. But macro run hone ke bad upar ke form ki entry cell ko niche jo = wale formule se link kiya tha vo hat ja rhe he.fir bad me upar form me entry karne par vo data niche ki sheet par show nhi ho rhe he puri sheet blank hi ho rhi he .mene 5 6 bar formula laga kar aur macro run kar ke dekha he plz solution batayiye
Gender kay bayghair fom un complete hay
Sir aap ne clear button nhe kraya hai 😮
I want learning from starting
th-cam.com/play/PLHjOos34ty4G2CICgC8l9n_SCMS-wo9yg.html
Sir, Data entry form में data feed करते समय mouse का इस्तेमाल करने से form को design करने का महत्व की ख़त्म हो जाता है,
मै चाहता हूं कि जो form हमने बनाया है उसमें tab button से एंट्री cell में cursor अपने आप चला जाए, कैसे करे
Cell lock karke ham aisa kar sakte hain iske liye bhi hamne bataya hai, jin cell me entry karni hai unko chhod kar baki puri sheet ko protect kar dene se aapki samasya hal ho jayegi
Download ka link to bataye
Pls provide file link
App nay gender ko and formula main add nahi kara subkay fom tou complete tub hoo ga jub gender fill nahi hoo ga really me
Mobile me work nhi kar rha
इसमें कंपलीट एंट्री कर सबमिट करने पर एंट्री डेटाबेस में ट्रांसफर होने के बाद दुबारा खाली फॉर्म को सबमिट करें तो खाली फॉर्म की एंट्री भी हो रही है इसको कैसे रोके
मतलब मैक्रो सबमिट बटन के ग्रीन नही होने पर भी चल रहा है इसको कैसे रोके
Great video, I have have small business need to make data entry format in excel tried but did not able, can u help. In. This give ur mail id I'll send my detail quarries
great work sir
Thank you for watching!