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

Sdílet
Vložit
  • čas přidán 24. 06. 2022
  • Fully Automatic Data Entry Software in Excel | Data entry form without user form and VBA Code
    #dataentryform #dataentrysoftware #msexcel #computergyanguruji
    Practice file download:
    drive.google.com/file/d/1dlPs...
    Our second channel
    / computergurujitechnical
    www.amazon.in/shop/computergyanguruji
    Follow us on
    instagram
    / computergyanguruji
    Twitter
    / c_g_guruji
    Facebook
    / computer-gyan-guruji-1...
    MS Excel Videos
    • Hindi English Dictiona...
    MS Excel for Beginners
    • MS Excel Tutorial for ...
    Excel VBA
    • Excel VBA
    MS Word
    • MS Word
    MS PowerPoint
    • MS Power Point
    MS Access
    • MS Access tutorial for...
    MS Paint
    • MS Paint
    MSW Logo
    • MSWLogo
    Notepad & HTML
    • Notepad complete tutor...
    CSS
    • Introduction to CSS | ...
    JAVA
    • JAVA Script
    PHP
    • PHP
    Python
    • Python
    Photoshop
    • Photoshop
    Full Tutorial
    • Full Tutorial
    Computer Education
    • Education
    Other
    • Other video
    Tally
    • Tally ERP.9 Rules of D...
    Internet
    • internet
    Computer GK
    • GK
    Google Sheet
    • google sheet
    Invoice in Excel
    • Invoice In excel
    Reasoning
    • Reasoning
    Airthmatics
    • Airthmetic

Komentáře • 132

  • @muhammadarif8006
    @muhammadarif8006 Před 2 lety +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

  • @qaziamanullah5873
    @qaziamanullah5873 Před rokem

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

  • @PD_incredible
    @PD_incredible Před rokem

    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.

  • @saghirahmadsindhu3401
    @saghirahmadsindhu3401 Před 2 lety +1

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

  • @sajujacob3648
    @sajujacob3648 Před rokem +1

    Super simple way of teaching, keep it up bro.

  • @user-jr8tf1tv8g
    @user-jr8tf1tv8g Před rokem

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

  • @romeshnixByte
    @romeshnixByte Před rokem +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

  • @ashokk8829
    @ashokk8829 Před rokem

    Thanks for imparting good knowledge.

  • @adityabansal6000
    @adityabansal6000 Před rokem

    Really nice and helpful... Thanks!

  • @lschopra4233
    @lschopra4233 Před 2 lety

    Simple, Amazing and useful

  • @ta20111996
    @ta20111996 Před rokem

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

  • @shadiaandnazia8686
    @shadiaandnazia8686 Před rokem

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

  • @akkushotto71
    @akkushotto71 Před rokem

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

  • @wonderlandtoday1165
    @wonderlandtoday1165 Před rokem

    Wow. Simply fantastic

  • @francedurandi5093
    @francedurandi5093 Před rokem

    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

  • @harshalsonawane7802
    @harshalsonawane7802 Před 2 lety

    Excellent Sir, Amazing tips sir

  • @narayanaraopitta7495
    @narayanaraopitta7495 Před rokem +1

    Sir you have wonderful teaching power

  • @khaliljabran6914
    @khaliljabran6914 Před rokem

    Great job ❤

  • @rslrslobo6026
    @rslrslobo6026 Před rokem

    Excellent sit

  • @francedurandi5093
    @francedurandi5093 Před rokem

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

  • @pariharchandan6897
    @pariharchandan6897 Před 2 lety

    Very informative sir....

  • @nandabthapa1017
    @nandabthapa1017 Před 6 měsíci

    Bahot hi achchha laga sir, thank you

  • @gurukamaleshgk2091
    @gurukamaleshgk2091 Před 2 lety

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

  • @sridharnalla8554
    @sridharnalla8554 Před 5 měsíci

    Superb make easy to forms

  • @pappubora506
    @pappubora506 Před 6 měsíci

    ❤️❤️🙏 Thanks Sir.

  • @memoricagraphics2156
    @memoricagraphics2156 Před rokem

    Valo lag6e daada darun aa6e

  • @neelakanthdhamannavar3227

    Excellent sir superb..👍🙏

  • @golamsorwar6685
    @golamsorwar6685 Před rokem

    Really appreciated

  • @bijaytanty8434
    @bijaytanty8434 Před rokem

    Thanks Sir

  • @gappersinghtamang54
    @gappersinghtamang54 Před rokem

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

  • @firojtadavi8802
    @firojtadavi8802 Před 2 lety +1

    Very nice Sir ji. .

  • @AsadAli-fd6mb
    @AsadAli-fd6mb Před 2 lety

    Sir, lots of love from Pakistan.

  • @dhanishmehta
    @dhanishmehta Před rokem

    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.

  • @user-op9jg8pw1g
    @user-op9jg8pw1g Před rokem

    Nice video

  • @esam2017
    @esam2017 Před rokem

    Thank you

  • @ravinderattri3637
    @ravinderattri3637 Před rokem

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

  • @koemny
    @koemny Před rokem

    cool, thanks

  • @KingKhan-zv1qz
    @KingKhan-zv1qz Před rokem

    Zabardast janab

  • @SmartBerry.
    @SmartBerry. Před rokem +1

    Thank you soooo much❤❤❤

  • @ITCE2018
    @ITCE2018 Před 2 lety

    Excellent

  • @thangammani8869
    @thangammani8869 Před rokem

    THANKS

  • @zdrashdi
    @zdrashdi Před rokem

    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.

  • @drshahidnadeemqadri4199

    GOOD

  • @ASHOK-tw4lg
    @ASHOK-tw4lg Před rokem

    THIS VIDEO IS THE BEST VIDEO

  • @rubinazafar-tk2xf
    @rubinazafar-tk2xf Před rokem

    Nice

  • @md.shafiqurrahman5721
    @md.shafiqurrahman5721 Před 11 měsíci

    nice

  • @innovationnew4670
    @innovationnew4670 Před rokem

    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

  • @anilr.mojidra9340
    @anilr.mojidra9340 Před 2 lety

    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

  • @jamshedpathan2269
    @jamshedpathan2269 Před 2 lety +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 Před rokem

      Pls continue this good work

  • @9428077512
    @9428077512 Před 2 lety

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

  • @jmbawesomevlog4029
    @jmbawesomevlog4029 Před rokem

    👍

  • @sureshgurjar5393
    @sureshgurjar5393 Před rokem

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

  • @mshahidfarooqui
    @mshahidfarooqui Před rokem

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

  • @mirbelal1818
    @mirbelal1818 Před rokem

    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 ?

  • @Mannabhav
    @Mannabhav Před 2 lety

    🙏💐🙏

  • @puneboy123
    @puneboy123 Před rokem

    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

  • @marhabaonlinebusiness7932

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

  • @gulhassan8270
    @gulhassan8270 Před rokem

    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

  • @bhaveshchotaliya1727
    @bhaveshchotaliya1727 Před rokem

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

  • @rameshabn843
    @rameshabn843 Před 2 lety

    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 Před rokem

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

  • @anime_channeljus12345
    @anime_channeljus12345 Před 2 lety

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

  • @gurjeetgill5044
    @gurjeetgill5044 Před 2 lety

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

  • @milestogo4805
    @milestogo4805 Před 2 lety

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

  • @noumanrana5393
    @noumanrana5393 Před rokem

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

  • @deepakkandpal2602
    @deepakkandpal2602 Před rokem

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

  • @perdaisabroad2389
    @perdaisabroad2389 Před rokem

    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 ?

  • @abusayed7918
    @abusayed7918 Před 2 lety

    pls sir I want a Stock management video

  • @sandip01_11
    @sandip01_11 Před 11 měsíci

    Sir I need multiple sheets entries for various items..

  • @pradeepkumar2294
    @pradeepkumar2294 Před rokem

    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

  • @mohiniparjapati1849
    @mohiniparjapati1849 Před 2 lety

    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

  • @pemalepcha2166
    @pemalepcha2166 Před 2 lety

    Sir how to set the print buttom in user form

  • @martandpangrekar2628
    @martandpangrekar2628 Před rokem

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

  • @Srout2385
    @Srout2385 Před 11 dny

    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

  • @nareshkumaryogi5313
    @nareshkumaryogi5313 Před 2 lety +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

  • @anis8518
    @anis8518 Před rokem

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

  • @dozendord
    @dozendord Před rokem

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

  • @nikeshtiwari9840
    @nikeshtiwari9840 Před rokem

    What if this video included with form creation too.

  • @navsaridapcu8212
    @navsaridapcu8212 Před rokem

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

  • @Anilsharma-jf9nt
    @Anilsharma-jf9nt Před rokem

    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

  • @AnilKumar-rr1qw
    @AnilKumar-rr1qw Před rokem

    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 Před rokem

    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

  • @d.r.officer348
    @d.r.officer348 Před rokem

    Sr foto ke sath form chrch print pasvrd Or kese kare

  • @nurserytoys
    @nurserytoys Před 2 lety

    #Excellent
    [ using macro = vba ]?

  • @shahidarain9679
    @shahidarain9679 Před 2 lety

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

  • @mudalivenky1957
    @mudalivenky1957 Před 5 měsíci

    Yedi name me sirf capital chahiye to kya karna hai ?

  • @gurukamaleshgk2091
    @gurukamaleshgk2091 Před 2 lety

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

  • @haridasbhangare
    @haridasbhangare Před 2 měsíci

    Unhide kaise karana hai

  • @firojtadavi8802
    @firojtadavi8802 Před 2 lety

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

  • @happytosif
    @happytosif Před rokem

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

  • @kuldeepsinh.purohit
    @kuldeepsinh.purohit Před rokem +1

    How to make form in Excel

  • @jigneshdadhaniya2548
    @jigneshdadhaniya2548 Před rokem

    How can get download work sheet with formula?

  • @sandeepsinghsolanki4892

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

  • @harekrushnanayak997
    @harekrushnanayak997 Před 2 lety

    Sir pl zoom the formula now

  • @sanjibjana4434
    @sanjibjana4434 Před rokem

    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?

  • @pagirahul2653
    @pagirahul2653 Před 6 měsíci

    Iske liye Kon sa Excel Use Kare

  • @spacejourneywithvimal3148

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

  • @HADI-UPDATE
    @HADI-UPDATE Před 2 lety +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.️

  • @sp_live
    @sp_live Před 2 lety

    Image કેસે ADD કરે

  • @cap10_thor
    @cap10_thor Před rokem

    HOW TO INSTALL OFFICE 2013

  • @Natrajtitre
    @Natrajtitre Před rokem

    क्या करना पडेगा