New Automated Data Entry Software in Excel | Data Entry Form in Excel | Data Entry in Excel

New Automated Data Entry Software in Excel | Data Entry Form in Excel | Data Entry in Excel
This video is about a Fully Automated Data Entry Form in Excel. If you want to make the task of data entry easy, then definitely watch this video. This video explains how you can create a fully automated data entry form without VBA coding. No major Excel Functions have been used in it.
So watch the video and if you find it valuable please subscribe our channel:
/ powerexbyjitendra
And if you want to download our file, click on below link:
==============================
drive.google.c...
==============================
Related Videos:
1. If Function in Excel in Hindi
• If Function in Excel i...
2. If Function in Excel With Multiple Conditions | Nested If Function (Hindi)
• If Function in Excel W...
3. Conditional Formatting with Formulas
• Conditional Formatting...
4. Conditional Data Entry in Excel Using Data Validation
• Conditional Data Entry...
5. How To Create Drop Down List In Excel Hindi
• How To Create Auto Upd...
6. How to use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel in Hindi ?
• How to use COUNT, COUN...
7. Option Buttons
• Search Data in Excel w...
8. Check Boxes in Excel
• Updating Payment Statu...
-------------------------------------------------------------
Other videos on Data Entry Form
1. How to Make Data Entry Form in Excel Using Macro in Hindi | Like a Software
• How to Make Data Entry...
2. Super Easy Excel Data Entry Form (No VBA) in Hindi
• Super Easy Excel Data ...
3. Data Entry Form in Excel without VBA | Data Entry in Excel | Like a Software
• Data Entry Form in Exc...
-------------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#dataentryform
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexby...
Contact Us:
Instagram: ...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

[@AHKHacker]

Very nice.. thankyou so much... Perfect and very smoothly teach everything

[@PowerExbyJitendra]

Thank you so much

[@mohankathe3332]

@@PowerExbyJitendra Why are you not helping us, I have asked you a question above, cannot add a second line in merge and center under(Terms and conditions)How did you add that in the video? Please reply...

[@ArunPKR]

@@PowerExbyJitendra button enabled even during white filled cell, allowing it for incomplete entry. how to disable it?

[@Dhoni466]

Kindly share Excel sheet

[@anikettribhuvan3674]

Thank you... This video helped me alot...♥️🙌

[@anirudhsinghrathore8372]

Sir it is very nice, but it save data even if all required cells are empty. So, any solutions for this?

[@JackAJ]

Sir Protected sheets me Marco Run kaise hoga?... Sir please help me and please make video on it ❤❤❤🙏🙏🙏

[@SumanSharma-cz3ur]

I followed all the steps correctly but after running the MACRO in my excel sheet no data showing. Can you tell me what is the reason?

[@parilchauhan4376]

You are having window 7 then it will not work

[@adityavlogtime]

10000 entry se fir se edit krna h to kaise karenge ye b btao sir

[@lordgaming3112]

Brother Can Make Hotel Booking Form For Google Sheet Please

[@jesieestrada5314]

I love your video tutorial, can you please make a video about Purchase request/Order in excel without VBA (source of fund, date of purchase, description, unit, price, total amount) in English version. thanks

[@allinoneyt2340]

Checkout learn Solutions channel

[@adda8474]

thanks yeh buhat acha hai BUT Submit button par saari fields fill na ho tab bhi macro run ho raha hai, please is ka koi hal bataiyay

[@shivshaktic2021]

Macro1 Won't work Properly to store data filled

[@HolyQuran0992]

Thank You so much very Easy without coding.. Really Professional

[@abroazhar]

great. apne is ek video me buhut kuch samjha diya... If function, Conditional Formatting, VBCode, Macro Recording, Some tricks to Hide data.... Amazing...

[@DML2024]

Very valuable video. Concept well explained. However how to choose stock when we have thousans of SKU. Would it not be exhautive when stock are in larger number ---- may be 5 to 10 thousnads.

[@badassentertainment1577]

Sir conditional formating me bass 1 hi show hora h

[@thinksync1]

jitendra ji, thanks a lot for valuable tutotrial, i need little more guidance over it, if somehow i need to add few things later on, or edit one of hte data, can you guide some way with the same kind of dashboard, to do edit or add more things.

[@aftabsmerchant1]

Sir Very simple easy to understand and informative vidieo, I downloaded the file also, but microsoft locked the file, can you share the Zip file

[@krishikatiwari9632]

Wow, a perfect teacher, aaj tak maine koi movie bhi 40 min lagatar nahi dekhi but your teaching style is birrliant. Bhagwan aapko samrridhi de.

[@PowerExbyJitendra]

It is your kindness. Thanks a lot.

[@SUNEELKANDA]

बहुत बार सीखने का प्रयास किया। बहुत कुछ सीखा। मैक्रो रिकॉर्ड करते समय भूल हो जाया करती थी। आसान भाषा में जब तुमने समझाया तब सच में उसको पूरी तरह समझ गया हूं। एक्सेल को सिखाने में बहुत सी पुस्तकें और यूट्यूब का और कंटेंट बनाने वालो का कोटी कोटी धन्यवाद। तुम्हारा विशेष रूप से धन्यवाद। मधुर वाणी के स्वामी हो। मेरा विशेष स्नेह स्वीकार करें। मैं सुनील काण्डा आगरा ताज नगरी उत्तर प्रदेश भारत से।

[@PowerExbyJitendra]

सुनील जी बहुत बहुत आभार 🙏

[@0074wd]

It's good my question is this database sheet should be protected and i hope u will make another video on this

[@hindiinfotech_official]

Your voice modulations is very fine Explaining techniques is 👍

[@PowerExbyJitendra]

Thank you so much

[@richculture4160]

Linked Picture and Appending records in the database through Macro is really excellent. So many years I have been using Excel but not knowing this powerful utility. Thanks for the same.

[@kosolhr6272]

Really Nice work thank you so much... I have one query can you please guide me? I want to prepare one form where employee and contractor serial number will fetch automatically in form.

[@learncomputer8744]

Impressive algorithms! The NSA Prop Firm Robot seems like a game-changer for precision forex trading.

[@idlesudhanshu]

Sir I want to make a calculator tool where I put a price, it should automatically calculate the value after my specified taxes, discounts, charges etc If you have a video related to this please share the video or take this as a suggestion 🙏🙏

[@himadrichowdhury9197]

You need access Request access, or switch to an account with access. Learn more.. YEH ACCESS NAHI HO RAHA HAIN ..Request sent You’ll get an email letting you know if your request was approved?????????????

[@aabdulrafay]

Kya hm asa nhi lr skty har bar macro record krna pry ga As nhi ho sakta ke recorded macro paka paka save ho jye....??

[@maqsoodul-hassan3470]

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

[@avikbiswas1046]

Good work but 1 problem.... If I click submit botton before its getting green,then incomplete form will save on database. Bcoz the macro is enable for saving form not for condition checking.

[@akhileshmishra865]

Right 👍

[@Nayemhossan-bf7vk]

Hi. I'm simla Noor From Bangladesh

[@PowerExbyJitendra]

Hello

[@infoStationpt]

The Best, smooth and simple way, Matchless, Thanks👍

[@PowerExbyJitendra]

Thanks

[@learnmore614]

How I publish my Excel database like publishing examination results.

[@nemalconsashutosh8665]

Hi, Thank you so much for the video, very well explained, made it simple but I am getting error message 1004. What to do. This is in two instances. One when entering info in database and second during clearing data. Please help.

[@jeremyjizzy1]

I want to say a BIG THANK YOU! Although i didnt understand the Language, i was able to follow the video!

[@smartrader123]

Thanks for helping video. Vai isi enty from pai search button kor sakteha. Or isko data entry application bansaktehato ek video bana dijiya

[@utsavneupane9434]

Hello sir , kya aap mari madat karoga, mujha ak stock book entry kaa data Chahiye. So please reply

[@PowerExbyJitendra]

Apko stock entry aheet chahiye??

[@utsavneupane9434]

@@PowerExbyJitendra yes . But mereko paint kaa stock book Chahiye. Please help me.

[@jasdeepanand8468]

Superb 💐🙏🙏thank God 🥹

[@mytube4458]

very nice sir, your teaching method is perfect and excellent but it is my problem when I apply formula =and(terms&condition=True,counta=simplynumber) show false but after filling data does not show true.please help me.

[@Bharatiya_Brothers]

please tell me how to edit saved data from entry form

[@CLEAR2050]

Hi bro You are formula (=IF(D3=‘’’’,’’*’’,1) Not working Can you help me how’s working

[@aznibas]

Wonderful teaching methodology. Keep up your teaching amazing way. Thank you.

[@PowerExbyJitendra]

Thanks🙏

[@nusratlines4947]

@@PowerExbyJitendra outstand job.. you teach very simply

[@jaguarnext6058]

I have just copied everything with a different Titles, entries are tranferring from Entry form to DATABASE Sheet but every single time there is a pop up stating "error code 9" can someone help

[@drsanty7009]

Brother plz explain , when i submit my data, my links got removed with it . What should I do to keep it

[@deepakchougule6805]

I have to create an Excel data entry form with two conditions: 1) In the first form, I have to enter data in 5 cells and submit it. 2) In the second form, I have to enter data in 5 cells corresponding to the first form. Please provide the answer for above question with examples

[@deepakchougule6805]

I have to create an Excel data entry form with two conditions: 1) In the first form, I have to enter data in 5 cells and submit it. 2) In the second form, I have to enter data in 5 cells corresponding to the first form. Please provide the answer for above question with examples

[@ceetravels9925]

Very nice.. thankyou so much... Perfect and very smoothly teach everything

[@vikashsaw7888]

even if cells are empty macro button is enabled, how to strict this ?

[@waseemhassan9334]

Hello Brother, there is an issue in transferring my form data into Database sheet, its showing an error and data is not successfully transferring? Can you please guide me? @PowerEX by Jitendra

[@trilochanjena3836]

by following the video i had made a similar software now but got stuck in adding update edit modify features.. plz help me today i am waiting.. plz reply and suggest some ideas⭕️

[@rushpubg3774]

bro i like the way how you explain all i just enjoy it and learn allot from this thank you so much

[@tapan4253]

sir mere pass ek data hai different companies ka. lekin jab me data entry krta hu to sari company ka data ek hi sheet me aaa jata hai lekin usse muje bhot issue hote hai, so muje kuch esa batae ki agar me data entry sheet me kisi bhi company ka data entrey kru to vo particular us company ki sheet me hi save ho means sari company seperate data save hone chaiye bajae ek sheet ke. esa koe formula ya trick hai to please batao.

[@feeder198]

how to disable the submit button macro if the button show in grey disable status? because i have follow the steps, at the end, the submit button still can click when it is grey (data not fully key in or no tick on term and condition). Any 1 can help?

[@waseemrajawingchunsgr4273]

I'm asking why????? Can't we directly enter data in sheet 2😮

[@prashantsharma611]

This I've created, thank you so much. But I also want to exit data from my workbook, how can i do that....?

[@davidcurry4433]

What version are you running, can this be done on a 2019 version

[@PowerExbyJitendra]

Yes

[@tapan4253]

sir muje ek help chaiye mene ek sheet me kuch buttons banae hai jisme mene sheets ko link kiya hai lekin, me chahta hu ki jab me kisi button pe click kru to same sheet me dusri wali sheet open ho, sheet 1 ke pass sheet 2 nhi aai chaiye, or apne jese database niche sheet dikh rahi hai vo dikhni nhi chaiye hide kre to vo button kam nhi krta isliye plzz esa kuch batao ki button se sheet open kre lekin new sheet me na dikhe same sheet pr hi open ho

[@mdabubokarsiddik7476]

In office 2007 submit not working whan creating picture format

[@sabiruli]

This is amazing bro. Very easy to understand. Thanks from Bangladesh

[@fahadahmed4879]

HI , LOVELY. VIDEO , HATS OFF I AM HAVING PROBLEM , WHEN I AM RUNNING MACRO , MY DATA IS REPLACING. (ITS NOT GETTING ADD IN NEXT SHEET , ITS JUST. REPLACE THE PREVIOUS DATA PLS HELP

[@mnaveenkumar521]

After saving in enabled workbook, saves creted. But after opening and saving some entries macro is not available saying

[@youtubegirl7777]

Sir zoom karke video bnao bahut chota dikhra h

[@AmitGautamGTech]

both links are same of Free file Converter and Encryption Tool

[@mynileEu]

@32:16 i could not undrestand, my macro record will replace the first row always . how should i fix this problem ?

[@sirankitrana]

Sir agar hume es form k andar baaki cells ko uneditable bana hai so that or kahi type na ho toh kaise krna hai??? please help

[@Learningsalways]

please provide file, mentioned google drive link is asking for access..

[@shahalamGuiterBabu]

Thanks , Its very need able.but I want to know gender bottom not always active when I click Its will active .please tel me .

[@TheManjunathcv]

Conditional Formating is not working ... only 1 number is appearing

[@PedroMartinez-nl1gr]

Great job, although I do not speak your language I was able to follow and understand the concept. Really appreciate your work and effort. Thank you .... and yes, I subscribed 👍

[@jinsutjain169]

If database is made hidden to save editing by staff then macros do not run Any help Nice video. Thanks🙏

[@moechebli3627]

What you make when the vidoe pass till 32 min what steps or keys you press it can you please write it here please waiting you

[@supriyamadiwal5466]

This is exactly what I was looking for; thank you so much for proper and clean instructions.

[@ravindrarajliwal7905]

Sir Packers And Movers Ki Billty. Ms Excel Me Kese Banti h ek video banao plzzzz

[@sarabjeetsinghkailay7657]

informative video.. its really helpful.. Thanks for explaining in details

[@PowerExbyJitendra]

Thanks

[@PrabhuArumugam]

Hi bro when i run the macro it is not getting recorded in database. Kindly help!

[@kanishkafashion]

This mecro not work in ms excel 2007

[@dharmendrapatel544]

Very nice program and useful too , but how to set Tab or Enter key to jump to the next entry cell kindly suggest for to do so that after data entry form created the entry will be more easy

[@DIYDCam]

very Nice Sir i have question if i want to edit some Entry which is saved in Database please explain

[@PowerExbyJitendra]

You can do it manually

[@pravinpatilofficial]

hi sir your explanation is very good and the form is very helpful to me, but let me know can I connect this form to my PHP website? please reply thanks

[@MUHAMMADFAREEZIQWANMOHDFUAD]

thank you for your tutorial. It is very helpful. But may I know why when I run the macros it overwrite the existing data instead of creating a new row? Thank you.

[@ramachandrajena9433]

See video again and make your sheet accordingly

[@mcdee367]

i have learned new things today. thank you very much sir.

[@PowerExbyJitendra]

Welcome

[@kaptanchaudhary1743]

THANK YOU SO MUCH , LEARN SOMETHING NEW

[@PowerExbyJitendra]

Thanks

[@jlofficial615]

dear sir when i submitted an alert cannot run the macro file name. the macro may not be available in this workbook or all macro may be disabled. how i can do it. thank best regard

[@additionaladvocate5827]

dear sir kindly teach us how to create automatic data entry form for contingency bill finance department

[@Manzoorhusyen]

Sir Ye data Entry form Website ya Social media per share Karen tou work Kary ga Us ka process bata dijye please

[@joyknow10109]

Hi Sir, I am Aziz can you tell me??? How to set Background picture of this Database please tell me???????????????????

[@BhaveshhPawar]

Great video, but add information in it for error for invalid entry, for example incase pin number entered is less than or greater than 6 digits or as any space or aplhabate gets entered then it will show error message and same for contact, date, reg. no.

[@sirabraracademy7790]

Can you help me I m facing problem in making form kindly help me

[@imdadhussain5856]

What A Video .. What A Style of Teaching ... Thank U So Much Sir .. I cant find words to describe your Kindness ...🥰🥰

[@PowerExbyJitendra]

Thanks you so much bro 🙏🙏🙏🙏🙏

[@AshokKar-x2j]

Very very good representation Sir. Thanks a lot.

[@emonthesoldier7327]

Such a great video. Learn many thing for many purposes. Thank you so much bro❤❤

[@PowerExbyJitendra]

Thanks a lot

[@vishnutu1312]

After entering data in database how can I filter these data

[@KEERTHIMKS2023]

I recommend my friends for see your videos for development of their excel skill to betterment. Thank you 🌹🌹🌹

[@PowerExbyJitendra]

Thank you so much

[@biswajitrai3574]

Thankyou so much sir Please make a search button And photo

[@kabirdagar2984]

Very slow pace video only meant for beginners and some problems we might face also not explained

[@Azam_Pakistan]

Very nice. Will this final form work on android MS Office too? If not then is there a free alternate to do the same on android?

[@hindu12259]

sir, Regards from UK..many thanks for your kind help.

[@Sammymusic4]

Sir I just able to one entry 2 entry is not enter

[@bantax2008]

Wonderful video, explained so clearly. Thank you!

[@kiranundi5167]

Sir fully automatic chit fund software banado sir

[@saghirahmed5459]

barri gal a g. ma computer to nai janta magar janab aap ne samjaya bohat acha ha. well done. and bravo!

[@m_jb_959]

Kiya excel to online web auto fill bana sakte hai

[@AdeebFaryadtech]

End formula wala Bix false hi likha rahta ha true ni hota