Fully Automatic Data Entry Software in Excel | Data entry form without user form and VBA Code

Поділитися
Вставка
  • Опубліковано 14 січ 2025

КОМЕНТАРІ • 133

  • @muhammadarif8006
    @muhammadarif8006 2 роки тому +3

    Excellent Sir Amazing, Aap ne hamari 1 Saal se Jo hum pareshan the woh aap ne aaj khtam kr Di hai. Thanks alot Sir

  • @shadiaandnazia8686
    @shadiaandnazia8686 2 роки тому

    Great video sir Jo ham 1month nhi Sikh paye apka 1 video hame sab sikha diya

  • @NafeesKhan-y7c
    @NafeesKhan-y7c Рік тому

    Namaskar Sir Ji, Aap ka video bahut hi Achha Laga. Aur aap ke bataane ka tarika bahut hi kabile tareef hai. Thank you Sir.

  • @gurukamaleshgk2091
    @gurukamaleshgk2091 2 роки тому

    Ji apto bade ache sikhate hei. Acha laga apse seekhna.

  • @francedurandi5093
    @francedurandi5093 Рік тому

    You are great sir. I have learnt this from you very easily. I am 64 years old

  • @nandabthapa1017
    @nandabthapa1017 Рік тому

    Bahot hi achchha laga sir, thank you

  • @memoricagraphics2156
    @memoricagraphics2156 2 роки тому

    Valo lag6e daada darun aa6e

  • @francedurandi5093
    @francedurandi5093 Рік тому

    I love your explanation. It's very very easy to understand. Now, I want to learn vba. So that I can develop an app for my project work

  • @SmartBerry.
    @SmartBerry. Рік тому +1

    Thank you soooo much❤❤❤

  • @narayanaraopitta7495
    @narayanaraopitta7495 2 роки тому +1

    Sir you have wonderful teaching power

  • @romeshnixByte
    @romeshnixByte 2 роки тому +3

    Wow, not only i learned the main purpose,
    i also learned many small concepts in between like assigning list to control by data validation, applying conditional formatting to controls, and so on. I have been working on vba and forms for long. i never thought there are simple ways like this.
    thank you brother from Manipur

  • @pappubora506
    @pappubora506 Рік тому

    ❤️❤️🙏 Thanks Sir.

  • @AsadAli-fd6mb
    @AsadAli-fd6mb 2 роки тому

    Sir, lots of love from Pakistan.

  • @rslrslobo6026
    @rslrslobo6026 Рік тому

    Excellent sit

  • @saghirahmadsindhu3401
    @saghirahmadsindhu3401 2 роки тому +1

    Your method of teaching is classic
    I got a lot of knowledge your videos

  • @PD_incredible
    @PD_incredible 2 роки тому

    Manoj Sir, Really a brilliant video in very simple Hindi. Your step-by-step explanation is amazing. Thanks lot of a very simple but amazing video.

  • @firojtadavi8802
    @firojtadavi8802 2 роки тому +1

    Very nice Sir ji. .

  • @ASHOK-tw4lg
    @ASHOK-tw4lg 2 роки тому

    THIS VIDEO IS THE BEST VIDEO

  • @akkushotto71
    @akkushotto71 2 роки тому

    I liked your video very much. very helpful- Thank you so much

  • @sajujacob3648
    @sajujacob3648 2 роки тому +1

    Super simple way of teaching, keep it up bro.

  • @qaziamanullah5873
    @qaziamanullah5873 2 роки тому

    Very interactive session. A nice, easy and understandable way of the communication.

  • @sridharnalla8554
    @sridharnalla8554 11 місяців тому

    Superb make easy to forms

  • @Usmanghani063
    @Usmanghani063 2 роки тому

    Excellent and very helpful. Thanks bro...👍👍👍

  • @wonderlandtoday1165
    @wonderlandtoday1165 2 роки тому

    Wow. Simply fantastic

  • @golamsorwar6685
    @golamsorwar6685 2 роки тому

    Really appreciated

  • @pariharchandan6897
    @pariharchandan6897 2 роки тому

    Very informative sir....

  • @ravinderattri3637
    @ravinderattri3637 2 роки тому

    सर् आप से हम्बल रिक्वेस्ट है आप excel filler की भी वीडियो बनाए

  • @ReenaChauhan-w7u
    @ReenaChauhan-w7u Рік тому

    Nice video

  • @esam2017
    @esam2017 Рік тому

    Thank you

  • @harshalsonawane7802
    @harshalsonawane7802 2 роки тому

    Excellent Sir, Amazing tips sir

  • @ashokk8829
    @ashokk8829 2 роки тому

    Thanks for imparting good knowledge.

  • @KingKhan-zv1qz
    @KingKhan-zv1qz 2 роки тому

    Zabardast janab

  • @adityabansal6000
    @adityabansal6000 2 роки тому

    Really nice and helpful... Thanks!

  • @lschopra4233
    @lschopra4233 2 роки тому

    Simple, Amazing and useful

  • @khaliljabran6914
    @khaliljabran6914 2 роки тому

    Great job ❤

  • @zdrashdi
    @zdrashdi 2 роки тому

    We chose to learn from your videos, because of your slow pace way of training each and every thing from start to end. But sorry to say your this video lack your that style you left many things and you looked in much hurry in training the rest things. Thks.

  • @koemny
    @koemny 2 роки тому

    cool, thanks

  • @thangammani8869
    @thangammani8869 2 роки тому

    THANKS

  • @mahuabose9632
    @mahuabose9632 2 роки тому

    Thank you sir

  • @ITCE2018
    @ITCE2018 2 роки тому

    Excellent

  • @bibhuduttabagar3946
    @bibhuduttabagar3946 2 роки тому

    Thanks sir

  • @md.shafiqurrahman5721
    @md.shafiqurrahman5721 Рік тому

    nice

  • @gappersinghtamang54
    @gappersinghtamang54 2 роки тому

    Thanks sir for excellent video. we wan to Navigation Panel in a excel vba project.

  • @drshahidnadeemqadri4199
    @drshahidnadeemqadri4199 2 роки тому

    GOOD

  • @RajeshYadav-d3u
    @RajeshYadav-d3u 11 днів тому

    Print ka option bhi add karayiye

  • @anilr.mojidra9340
    @anilr.mojidra9340 2 роки тому

    namste sor video bahut achha or usefull he thank u
    submit vala main page kese banaiye vo batane ki kupa kre yato is ke upar koi video ho to link send kre

  • @innovationnew4670
    @innovationnew4670 Рік тому

    very nicely explained but a small query if i entered data in the form and passed to data sheet but due to some unforeseen reason i want to revert or remove data from data sheet and re-enter again, then how do i do that please explain .... Quick reply is appreciated

  • @jamshedpathan2269
    @jamshedpathan2269 2 роки тому +1

    Sir very nice and knowledgeable video. Sir can we send this form as link to someone to fill and will that filled form will be shown in our data sheet.??

    • @srinu7779
      @srinu7779 2 роки тому

      Pls continue this good work

  • @bhaveshchotaliya1727
    @bhaveshchotaliya1727 Рік тому

    measurement sheet automatic kese banaye..or abstract sheet automatic kese banaye..sir ..please ek vidio dikhaye

  • @mshahidfarooqui
    @mshahidfarooqui 2 роки тому

    thanks, How i can protect data sheet infully automatic entry software in Excel

  • @sandip01_11
    @sandip01_11 Рік тому

    Sir I need multiple sheets entries for various items..

  • @9428077512
    @9428077512 2 роки тому

    VERY GOOD SIRJI , YOU GIVE ONLY TWO OPTION WE WANT ONE MORE OPTION AND THAT IS SERCH SO HOW I CAN DO THIS ??

  • @puneboy123
    @puneboy123 Рік тому

    I am using this method for cheque issue however I have multiple Items under paid to and for so when I am using submit it is adding however not appending the new items it is overwriting the old data and replacing with new one

  • @noumanrana5393
    @noumanrana5393 Рік тому

    Sir give two more buttons for "Find" and "Edit" as well

  • @gulhassan8270
    @gulhassan8270 Рік тому

    Sir can we save data form save data in multiple data base sheets like BS English,BS Computer science) we enter data of student and data form save data into concern department data base sheet

  • @wardabloging
    @wardabloging Рік тому

    Sir I have 1 question : I followed you as you did but when I save it then open not working . Can you help me how it will work again when i open ?

  • @kuldeepsinh.purohit
    @kuldeepsinh.purohit 2 роки тому +1

    How to make form in Excel

  • @deepakkandpal2602
    @deepakkandpal2602 2 роки тому

    Sir muje 1 big data se kuch prsent data fetch krna hai. Uske lie vba mai kese coading hogi. Please 1 lessn bna deejiye..

  • @jmbawesomevlog4029
    @jmbawesomevlog4029 2 роки тому

    👍

  • @sureshgurjar5393
    @sureshgurjar5393 2 роки тому

    Excellent sir, but can we use here vlookup formula so that for name, father's name automaticlly comes. If yes, how?

  • @Srout2385
    @Srout2385 6 місяців тому

    Sir ji mera ek chhota sa fruits ka shop hei me uska hisaab rakhna chahta hun exl me to kya aap ek exl bana denge hamare liye
    jeise aap stock maintain ka exel banaye hei usitarah aap ek exle banaiye jisme -income ,expenses and profit,loss and savings show karega

  • @martandpangrekar2628
    @martandpangrekar2628 2 роки тому

    Sir इस form को school bonafide sheet le cell ke sath kaise link kare

  • @mohiniparjapati1849
    @mohiniparjapati1849 2 роки тому

    Sir aap esh excel sheet ka format description m sheet upload kr digiye
    Hmare liye or asan ho jayega only name change krne hoge
    Upload kr digiye sir

  • @nareshkumaryogi5313
    @nareshkumaryogi5313 2 роки тому +1

    good morning sir,
    is form me search ka option bhi hona chahiye jis se agar koi mistake ho jaye to use thik kar sake. please usko bhi isme add kare sir aur uska bhi video banaye

  • @d.r.officer348
    @d.r.officer348 Рік тому

    Sr foto ke sath form chrch print pasvrd Or kese kare

  • @mirbelal1818
    @mirbelal1818 2 роки тому

    Its really good topic. But if i want to protect the back up data sheet, the macro is not working. How can i protect my back up data sheet ?

  • @marhabaonlinebusiness7932
    @marhabaonlinebusiness7932 2 роки тому

    Please let me know where i can find in excel that sheet to make form

  • @anis8518
    @anis8518 2 роки тому

    Hum date ek column mein input karte hai aur us date mein se related entries usi sheet mein kaise automatically generate kare

  • @dhanishmehta
    @dhanishmehta 2 роки тому

    Great Video Sir........
    With the given understanding, I have one other issue if you can resolve........
    In the primary Data entry - I have multiple products with diff qty and diff rates, one form may have 5 products and others may have 3, 6, 8 and so on.........Now if i give formula for max 10 rows and through Macro it will go 10 rows despite form could have diff rows for diff forms as it is being Paste special........
    How do I resolve this as I need to run macro till the filled up rows.
    Thanks in advance.

  • @spacejourneywithVIMAL
    @spacejourneywithVIMAL Рік тому

    Sir har baar new sheet ban rhi hai baki sb to thik hai plz tell me.

  • @Anilsharma-jf9nt
    @Anilsharma-jf9nt 2 роки тому

    Sir mien user form meta complete ban Jata hai par jab file close Karle subarachnoid open latte grin to macro enable not work go jata hai

  • @dozendord
    @dozendord Рік тому

    क्या इस फॉर्म को ऑनलाइन वेब फॉर्म में कन्वर्ट कर सकते हैं ?
    इसे url के द्वारा ओपन किया जा सकता है क्या?

  • @Mrone-b3z
    @Mrone-b3z 2 роки тому

    Hello sir Mujhy ap se attendance ki file k bary m kuch help chaye

  • @milestogo4805
    @milestogo4805 2 роки тому

    how to work modify button?please make a video on it

  • @mudalivenky1957
    @mudalivenky1957 11 місяців тому

    Yedi name me sirf capital chahiye to kya karna hai ?

  • @Mannabhav
    @Mannabhav 2 роки тому

    🙏💐🙏

  • @sandeepsinghsolanki4892
    @sandeepsinghsolanki4892 Рік тому

    Sir ek do entry dalne ke bad run time error aa rha he uska solution bataye

  • @pradeepkumar2294
    @pradeepkumar2294 Рік тому

    Sir company ke Delivery challan aur outward, onwards Register ka software banane ka bhi Vedio bana bana do jisme challa open aur aur close kab hua please sir

  • @hazy83
    @hazy83 2 роки тому

    Sir credit account for petrol pump k lieye any excel sheet available plz share kijieye ga.

  • @nikeshtiwari9840
    @nikeshtiwari9840 Рік тому

    What if this video included with form creation too.

  • @nurserytoys
    @nurserytoys 2 роки тому

    #Excellent
    [ using macro = vba ]?

  • @gurukamaleshgk2091
    @gurukamaleshgk2091 2 роки тому

    Mei ek teacher hu. Mujhe bachonke bank banana hei school me. Use suit hone wala excel me idea dijie

  • @pemalepcha2166
    @pemalepcha2166 2 роки тому

    Sir how to set the print buttom in user form

  • @pagirahul2653
    @pagirahul2653 Рік тому

    Iske liye Kon sa Excel Use Kare

  • @shahidarain9679
    @shahidarain9679 2 роки тому

    Sir userform open ho TU hum excel kase Kam kar sakte ha.

  • @jigneshdadhaniya2548
    @jigneshdadhaniya2548 Рік тому

    How can get download work sheet with formula?

  • @anime_channeljus12345
    @anime_channeljus12345 2 роки тому

    Sir,can you tell how to make roboat in msw logo

  • @abusayed7918
    @abusayed7918 2 роки тому

    pls sir I want a Stock management video

  • @AnilKumar-rr1qw
    @AnilKumar-rr1qw 2 роки тому

    Dear Sir,
    Ye file close karne ke baad macro disabled ho jata hai aur dubara entry nahi ho pati hai. Please tell about again entry after closing the sheet

  • @maqsoodul-hassan3470
    @maqsoodul-hassan3470 2 роки тому

    bahi mujay same iis tarah ka dat entry project chy but autmtic calculation bi kareen then data save karay for example
    sale --- item detail---- qty----- discount------ sale tax 17% ------- net amount
    plz reply soon

  • @rameshabn843
    @rameshabn843 2 роки тому

    Hi, can you share the videos of image link from the drive into display of images in the google sheet which captured from google forms.

    • @gopalchandradas5449
      @gopalchandradas5449 2 роки тому

      Sir, a lot of thanks..sir why per entry automatically create a new sheet? Please slove this

  • @navsaridapcu8212
    @navsaridapcu8212 2 роки тому

    how xml file convert to excel file or how to create XML AND Report in Excel file

  • @sanjibjana4434
    @sanjibjana4434 Рік тому

    Sab samjh mein aya. Par database sheet pe niche se data q submit ho raha hai? Jaise aapne R101 pahele uske bad R102 submit kiye hain.lekin database pe R101 k upar serial number pe R102 aaraha Hai.aisa q? Isko kaise kare ki 101 k niche 102 .... aa Jaye?

  • @firojtadavi8802
    @firojtadavi8802 2 роки тому

    सर जी एखाद application treasury के बारे मे try करे Opening balance every day receipt payment Closing balance tally With Cash with denomination..

  • @haridasbhangare
    @haridasbhangare 8 місяців тому

    Unhide kaise karana hai

  • @harekrushnanayak997
    @harekrushnanayak997 2 роки тому

    Sir formula is not visible

  • @gurjeetgill5044
    @gurjeetgill5044 2 роки тому

    GOOD EVENING SIR
    I WANTS TO KNOW THAT HOW WE CAN CONVERT excel vba user form into exe installable file

  • @aqstore3432
    @aqstore3432 2 роки тому

    time error 9 araha he kese solve hoga

  • @lalamusic-x7c
    @lalamusic-x7c 2 роки тому +1

    Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy.️

  • @rajesh.634
    @rajesh.634 2 роки тому

    Sir sheet insert ho raha tha jitne bhi data bana rahe hai to

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  2 роки тому

      Aapne macro recording ke dauran sheet insert ki hogi, pahale hi ek sheet le kar rakho