How to Make Data Entry Form in Excel Using Macro in Hindi | Like a Software

Поделиться
HTML-код
  • Опубликовано: 4 фев 2025

Комментарии •

  • @RudraPrasadGupta-n4y
    @RudraPrasadGupta-n4y Месяц назад

    Thank you so much Sir. This video is very much essential, important and helpful for all MS Excel Macro lover. This is an extraordinary task that is automatically hidden entry sheet after each entry.

  • @khalidmajeed2886
    @khalidmajeed2886 3 года назад

    sir, mashallah bohat mehnat saay aap naay explain kia haay.,,,,,,,

  • @guljee11
    @guljee11 Год назад

    I tried and ... successful. thank you. Now I'll do it for our school record.

  • @jupitermkk
    @jupitermkk 3 года назад

    Bahut badhiya sir

  • @SATNAMSINGH-oc6yl
    @SATNAMSINGH-oc6yl 3 года назад

    bhut hi helpful video hai sir.... thank u so much...

  • @VisualKreation
    @VisualKreation 3 года назад

    Bahot Bahot Shukriya Sir...Really Helpful Video..TQ

  • @ynagrajyadav
    @ynagrajyadav 2 года назад

    Superb sir 👍👍👍

  • @muhammadzahidali7989
    @muhammadzahidali7989 2 месяца назад

    aapki video se kamyabi mili zabardast 31224

  • @shuaibmalik6578
    @shuaibmalik6578 4 года назад

    Bhai very good, very easy method to transfer data. good job.

  • @shashinigam007
    @shashinigam007 3 года назад

    Very Practical n useful ..... Like n recommend ur videos in my friends ...... Thankyou very much Sir....

  • @pankajupadhyay8359
    @pankajupadhyay8359 3 года назад

    thankyou for uploding this video ,

  • @aqeelahmad8237
    @aqeelahmad8237 3 года назад

    Superb
    Very interesting

  • @jayanthamadasekera8248
    @jayanthamadasekera8248 Год назад

    Thank you so much for your quick response. Well done and very good design. I would like to make a request if you can insert caption in english it will help a lot for every body out side India

  • @gyan2byhemu145
    @gyan2byhemu145 2 года назад

    you are a excellent quality teacher

  • @nagendraprathap9697
    @nagendraprathap9697 4 года назад

    Very useful informative video Sir 👍👍🙏🙏

  • @Shree.Krishna.
    @Shree.Krishna. 4 года назад +1

    Excellent video... Thanks all the best..👍

  • @ahsanullah3939
    @ahsanullah3939 3 года назад

    Very very Nice 👍 sir I Love your work...thanx for uploading such a good video

  • @mazherali2965
    @mazherali2965 2 года назад

    Great work.😊

  • @azharaliazhar
    @azharaliazhar 4 года назад

    Splendid... Super....

  • @Amarjit82
    @Amarjit82 3 года назад

    Very useful .

  • @muhammadmobeen7160
    @muhammadmobeen7160 3 года назад

    All the best

  • @mohammedadeladi1680
    @mohammedadeladi1680 3 года назад

    Wawooo great thanks sir

  • @bittu25
    @bittu25 Год назад

    Thanks for teaching macro.

  • @NasirKhan-bl3xi
    @NasirKhan-bl3xi 3 года назад +1

    Bahut acha laga prog mujhe sir but is Mai mujhe agar baad Mai kuch aur bhi addition karna hai to kaise Karen sir aur delete kaise Karen yeh bhi batayen sir

  • @doloresdsouza5721
    @doloresdsouza5721 2 года назад

    excellent explanation

  • @AliKhan-om6yd
    @AliKhan-om6yd 4 года назад

    Superb ... Very Nice. Stay blessed Thanks

  • @accountingbasicbangla1569
    @accountingbasicbangla1569 3 года назад

    very nice..That's really helpful sir... Thank you for make it with very simple way..

  • @maheshrajapaksha4672
    @maheshrajapaksha4672 3 года назад

    Good job

  • @sanathsaja9840
    @sanathsaja9840 3 года назад

    Good lesson

  • @allaiba.R
    @allaiba.R 3 года назад

    I like u so much Ur Video very Help Full

  • @delwarhossain7200
    @delwarhossain7200 4 года назад +1

    Excellent Boss! Though I am not a Hindi speaking guy but your every word is crystal clear to understand. I love it!!

  • @Sammy-xv7mq
    @Sammy-xv7mq 4 года назад

    Sir your video are amazing
    Very nice and you make everything look easy and so understandable

    • @PowerExbyJitendra
      @PowerExbyJitendra  4 года назад +1

      Thank you man
      I am very happy with your comment.

    • @Sammy-xv7mq
      @Sammy-xv7mq 4 года назад

      Sir, Can I please ask if you have a video about food cost & pricing
      Same format as the stock version
      So you also give training sir
      Please advise
      Thank you sir

  • @shanikhan1854
    @shanikhan1854 4 года назад

    Most helpful video

  • @shaykh_dubai
    @shaykh_dubai 3 года назад +1

    Gained some quality knowledge from you sir👍

  • @sagni2980
    @sagni2980 4 года назад +1

    Very effective information.
    Pls make video ,if we record wrong data by mistake, how can we delete and edit from dashboard.
    Thanks

  • @deepakdalal8731
    @deepakdalal8731 4 года назад

    Superb 👌👌👌

  • @nileshss9123
    @nileshss9123 4 года назад

    Thank you sir....wao....nice

  • @maqsoodali3127
    @maqsoodali3127 3 года назад

    Sir good job .lekan sir print ka tarka zara batho plz

  • @wajid_hussain_balouch
    @wajid_hussain_balouch 2 года назад

    Weldone

  • @muhammadhussainyousaf5581
    @muhammadhussainyousaf5581 4 года назад

    Very informative video.

  • @Nicky3286
    @Nicky3286 11 месяцев назад

    THANK YOU SIR

  • @muhammadmobeen7160
    @muhammadmobeen7160 3 года назад

    Excellent

  • @SehrawatFitHealth
    @SehrawatFitHealth 4 года назад

    shandar video 🙏

  • @naumanvola
    @naumanvola 4 года назад

    great job keepit up

  • @viswanathancr2801
    @viswanathancr2801 4 года назад

    good video

  • @truptispassionforcooking3401
    @truptispassionforcooking3401 2 года назад

    Thanks Sir

  • @selwynjoseph3717
    @selwynjoseph3717 4 года назад

    Very usefull sir

  • @tssddqqsdi9010
    @tssddqqsdi9010 Год назад

    sir i have little bit issue .auto data save is start but not in next row. just save on first row . can you give me advice about that

  • @Amar-Jeet_Kullu
    @Amar-Jeet_Kullu 3 года назад

    Thanks a lot sir. You explained it in a simple and effective way.
    #AmarJeetKullu

  • @sunilshrestha5073
    @sunilshrestha5073 2 года назад

    Can we keep icons on the desktop of this excel like other software where we can open directly?

  • @mahmoudabouzaid8836
    @mahmoudabouzaid8836 2 года назад

    hello and thanks for this useful videos i'm asking about adding bottom for Search about data at specific date or specific name and what about print this data after search

  • @nilkamalkumar1015
    @nilkamalkumar1015 3 года назад

    Sir hospital ke liye ek data entry ka video banaiye

  • @mayuddinsipai4906
    @mayuddinsipai4906 4 года назад

    Great sir

  • @ujjwalpanda79
    @ujjwalpanda79 3 года назад

    Thanks Dear,

  • @atiqurrehman1946
    @atiqurrehman1946 4 года назад

    Good night my dear, it's excellent.

  • @kingcinema5295
    @kingcinema5295 3 года назад

    sir how serial number automatic change kese hoga isme q k jo entry kar raha he use to nhi pa ta hoga k ab konsa serial type karna he

  • @VeerMotionGraphics
    @VeerMotionGraphics 3 года назад

    Dear,
    Is it possible the same entry form for more distributor having data save in separate sheet and also search option to retrieve data for search.

  • @gajendrasingh9486
    @gajendrasingh9486 3 года назад

    Thank you for useful video...how to get gst number by name and sales invoice by serial number

  • @learnteach1228
    @learnteach1228 3 года назад

    Dawood bhai video is very nice but we need how to
    formulas in macro recording and also with drop down list in excel 2019

  • @priyavicky3131
    @priyavicky3131 4 года назад

    Nice 👌

  • @bittubhasin4909
    @bittubhasin4909 4 года назад

    Good sir
    Thanks

  • @shivkumar-er8wx
    @shivkumar-er8wx 2 года назад

    sir jee data entry form me igst cgst sgst bhi add karake bataye

  • @qaisarshehzad9620
    @qaisarshehzad9620 2 года назад

    Sir, You have done a great Job. Can you Tell me how to save this file.

  • @muhammadalamnizamani1087
    @muhammadalamnizamani1087 3 года назад

    Akhri Cell me se data save karnay k liye enter use karna chahye na ka mouse,

  • @ravikaushik533
    @ravikaushik533 3 года назад

    Costing sheet banani hai jisma kuch data fixed hote hai jo hide rakahana hota hai or khuch entry karne se kisi product ka price nikal jaye to usko kaise banaye pl

  • @disauyanmis5933
    @disauyanmis5933 4 года назад +3

    Great job! Thanks a lot. Was Always stuck, just understood I need to use “relative references”.

  • @subhashbaviskar6015
    @subhashbaviskar6015 3 года назад +2

    Sir, data entry main date aur drop down list auto hosakti kya? aur data date wise sort kaise hoga

  • @arunsharma07
    @arunsharma07 8 месяцев назад

    I followed your video but when I'm making another entry it getting replaced by previous one instead of palcing data below that cell

  • @ManojGupta-nl8fj
    @ManojGupta-nl8fj 3 года назад

    Sir kya intery ke liye sabhi cells ko krambaddh ek ke niche ek hona jaruri hai?

  • @dhanrokaha2941
    @dhanrokaha2941 3 года назад

    Hello Jitendra ji I am follow your guide line a did but i save data and next reopen and enter data and save can not save, can not see the macro display
    how can i adjust please let me know

  • @alializadeh8195
    @alializadeh8195 Год назад

    Thanx

  • @NasirKhan-bl3xi
    @NasirKhan-bl3xi 3 года назад

    Ek prog sir banayen Kai his Mai create adding delete save kaise Karen bataon sir ek prog bhi banaon sir

  • @23129696
    @23129696 3 года назад

    Well Explained... Is there is option to get drop down while doing data entry. And if we want to modify the data, how we can do

  • @memerworldxx7
    @memerworldxx7 2 года назад

    isko save kis format me karna hai.

  • @nimeshpateldesad3016
    @nimeshpateldesad3016 3 года назад

    Sir keyboard se save butan ke se bana te he

  • @abuhasanpalash09
    @abuhasanpalash09 3 года назад

    Thank you i Watched the video...? I am from Bangladesh. I want to talk with you about the data entry sheet. I want to more update like percent calculation system and including invoice

  • @RikhiRY
    @RikhiRY 4 года назад +1

    Wow..... very useful video sir.... but data mistake entry hogaya to edit karke correct kaise karein sir ? Plz

  • @tech-journey2946
    @tech-journey2946 3 года назад

    Kya ye chij hum ms office 2007 me kar sakte he ya nahin.

  • @Im.sarup1111
    @Im.sarup1111 3 года назад

    Thank you sir. Can you help me,Which screen recorder you have used?

  • @bhadrabdrshahi5539
    @bhadrabdrshahi5539 4 года назад

    Thank u sir

  • @shaileshtapadiya2456
    @shaileshtapadiya2456 3 года назад

    Sir I can tried, micro also recorded but entry in second page in first line, when we are doing second entry such entry replace on first row

  • @whatsappstatusguru1768
    @whatsappstatusguru1768 3 года назад

    Sir mene apka video dekhake ye full formate bana liya ekdam easily.
    Ab agar hamnko customer ke name wise alag se uska month vise bill banaha ho to hum kese bana shakte hai ?

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 года назад

      Aap entry format apni zaroorat ke hisab se hi design kariye

  • @mohdarmugaan7418
    @mohdarmugaan7418 3 года назад +1

    Sir file open kar rehe hai to security warning macros have been disable ke option s aa raha hai is me enable nahi aaraha hai solution batao

    • @aqeelahmad8237
      @aqeelahmad8237 3 года назад

      Go to File/Excel Option --> Trust centre --> Setting --> Macro Setting --> Enable Macro

  • @pratapsahoo4157
    @pratapsahoo4157 4 года назад

    Thank you very much for the video, came to know usage of "relative references"

    • @PowerExbyJitendra
      @PowerExbyJitendra  4 года назад

      Please watch this video :
      ruclips.net/video/weBuCZWrcTM/видео.html

    • @pratapsahoo4157
      @pratapsahoo4157 4 года назад +1

      please let me know how to edit a previous entry which is found wrong

    • @PowerExbyJitendra
      @PowerExbyJitendra  4 года назад

      @@pratapsahoo4157 you have to visit to data sheet

  • @BharatKumar-fh7ei
    @BharatKumar-fh7ei 3 года назад

    Super.
    Not necessary for userform.

  • @alanrashid9037
    @alanrashid9037 2 года назад

    HI Bro .... when I run the macro, it overwrites the data on the existing row in the datasheet.... please guide me where I m doing mistakes.

  • @netkingmahin
    @netkingmahin 4 года назад

    nice

  • @_the_chitransh
    @_the_chitransh 3 года назад

    Kya isi trah ka form Google sheets me bhi banaya ja sakta hai?

  • @farihah791
    @farihah791 3 года назад

    Thanks for the video, however how do i add a table and it works the same? I’m trying to use this for logging orders from customer and have a table but its not working

  • @SATNatureQuest
    @SATNatureQuest 4 года назад

    for data entry easy to create thanks but after dataentry any modification correction reqd it will be fetched?

  • @subhasishbhattacharjee8510
    @subhasishbhattacharjee8510 3 года назад

    👍 one question, i have a format where data is getting transfer, but data locking is not happening, if I press delete button data get deleted. Hiding the sheet option i don't require. Please help out in this subject. Your way of explaining is very appreciable. Thank you.

  • @muslimsunity6967
    @muslimsunity6967 3 года назад

    hello bro
    ihave a problem when i tries to record an other record the system gives me an error of Run time error ''9'' and subscript out of range plz let me know the solution

  • @akbarhosen5215
    @akbarhosen5215 3 года назад

    how to entry various product from only one invoice? (without repeat or fill up whole from or dash)

  • @amigosautomotives876
    @amigosautomotives876 4 года назад

    Good Presentation, anybody can easily understand how to work in excel. Thank you for uploading this kind of video and helped many people in their regular admin work.

  • @biswajitkaran89
    @biswajitkaran89 3 года назад

    Sir, very very amezing , interesting and informative that I not seen before. But Sir , two quetions -1) how can I open the Data Entry Dashboard in the next time after closing and 2) how can I calculate the mathematical operations . Sir , please response.

    • @PowerExbyJitendra
      @PowerExbyJitendra  3 года назад +1

      Biswajit ji please save the file as Excel Macro Enabled Workbook it will definitely work next time

    • @yaseryasu7145
      @yaseryasu7145 3 года назад

      @@PowerExbyJitendra can you explain in details. Mathematic calculations

  • @shaikhfiroz4007
    @shaikhfiroz4007 4 года назад +1

    Sir can you send a vedio for medicine billing invoice in excel & link with stock, sales & purchase.

    • @usama8464
      @usama8464 3 года назад

      I also need what u have questioned.

  • @muslimsunity6967
    @muslimsunity6967 3 года назад

    dear am working at a small shop of cloths, i want to maintain daily reecord with add buttons in relevent feilds and payments as well will you plz help me out. waiting for your helpfull response

  • @kunalsharma8319
    @kunalsharma8319 4 года назад +1

    Grand salute what a nice explanation. Sir I m ur fan now. Excel to ab apki hi video se sikhunga. But how can I contact u?

    • @PowerExbyJitendra
      @PowerExbyJitendra  4 года назад

      Dear Rajan great thanks for your lovely compliment and kind support

  • @mangalsinghchauhan8899
    @mangalsinghchauhan8899 Год назад

    How to make data uneditable after transpose into database.

  • @aleemshaikh669
    @aleemshaikh669 3 года назад

    Awesome✓✓✓✓
    Bt Sir Save Data ka button fix ho jayega ya move hoga place se bcz shape tool se draw kiya gaya hai.