Fully Automated Data Entry User Form in Excel | No VBA
HTML-код
- Опубликовано: 29 июл 2022
- Fully Automated Data Entry User Form in Excel | No VBA
In this video tutorial you will learn how to create a data entry user form with database without VBA Coding. Even if you are a excel beginner, you can learn to create it easily. Niether VBA coding nor excel large functions have been used to create 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.com/file/d/1udRI...
==============================
Related Videos:
1. IF Function
• If Function in Excel i...
------------------------------------------------------------
Other Videos On Data Entry Form:
1. New Automated Data Entry Software in Excel
• New Automated Data Ent...
2. Data Entry Form in Excel without VBA
• Data Entry Form in Exc...
3. Super Easy Excel Data Entry Form (No VBA) in Hindi
• Super Easy Excel Data ...
----------------------------------------------------------
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/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
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
Brilliant job, I was looking for it for quite a time, I successfully made a DATA entry form my my work, which will save lot of time for me. Your video was long but worth watching it. thank you again. from Pakistan
Very good lesson. I have learned a lot. And I appreciate your patience.
I'm not interested before the video but now I'm interested to learn, very well explain keep going good luck
Aap mey ek quality ha aur wo ye k
Aap bohat ache se dhere dhere samjhate hai. Many many thanks🙏.
God bless you🙏🙏🙏
thank you bro, this video is awesome to everyone and you are great.
Dear Sir Jitendra very professionally explained step by step and very slowly for students to follow and grasp in mind. I salute to you
Thank you so much bhai
Wonderful. Thankyou so much for making an excellent video.
Thanks🙏
Excellent Video. thanks so much. Let me know how to search, modify & delete the existing data using the combo buttons.
Great video. I follow your instructions every step. It works great. Thank you so much for the valuable knowledge. I can't wait to take more lessons from you.
Thank you so much
@@PowerExbyJitendra You are such great teacher. Although I do not understand the language I can make that work. I am very happy to find you. I will take more lessons from you. Thanks for teaching the world.
do you make video in English? as we all need one please. Thanks a lot for your time and hard work. Greatly appreciated your kindness for quick reply
@@PowerExbyJitendra If you need to develop a program with 70 fields and most of these are drop down combo boxes. Would Excel or Access be better? thanks
I do agree with TDS, where can we retrieve an extract of the data based on a month's entry, as i am planning to create this for my Leave tracking Tool that would follow similar working steps
great..thank u for sharing such wonderful knowledge😊😊😊
Thank you so much😊
After save if the entry form still filled it could be easy to double save the data..little modification needed to avoid double save data..
Nice👌👌 but form should be cleared on clicking the save button only.
Well narrated. Great
Thanks
I am very happy to learn the lesson ☺️ Thanks Dear sir
Thanks
bahut acha bataya sir apne or ish tarah ke vedio banaye sir 🙏🙏🙏🙏🙏🙏🙏
Thank you so much
Ye VBA code me aata hai yadi aapko VBA aata hai to aap code karke bhi ese easy way me bana sakte hai
Aur bhi advance project bana sakte hai yadi aap excel shikhe hai to VBA jarur shikhe VBA Excel ko aur bhi advance bana deta hai
Formula cruise trineein neet
Dear sir , After I saved even if enabled micro work book error still appear on sheet when I click on “data save”
The errr is “ Microsoft Visual Basic
Run-time error ‘9’
Subscript out of rang
Thank for your tutorial video ❤
Excellent. very useful.
MashahAllah Behtreen
Mashalllah Good Job Apka Samjhane ka tareeqa Bohat Hi acha ha keep it up
Thanks a lot
I am very much happy to learn. Thank you very much dear. Take care
Thanks 🌹🙏
बहुत बढ़िया समझाया आपने
धन्यवाद भैया🙏
धन्यवाद
Very Good tutorial.
Sir after creating this form and database sheets , can we use this in mobile version excel sheet?
Nice videos. thanks for such informative videos. I am a beginner for excel. i also have some queries. if you please help
Thanks sir bahuy helpfull he thanks
Thank you sir jitendra very helpful video and today i learn new think about excel alot of thanks 🥰🥰
Thanks Bhai
@@PowerExbyJitendra bro how to use tab while making data entries?
Thank you so much
Beautiful Entry Form
Really the great explanation, try how to use it in mobile
Shandar tutorial
Thanks you Boss I enjoy this letacher. Good letacher. ALLAH ap ko Khush rkhy Ameen. I am in Pakistani.
Thanks for your beautiful words.
I learned well after seeing 2 times thanks
Welcome
@@PowerExbyJitendra sir pic ka button kaisy add karengy please
Hi, i am very interested in learning more such things, can you make a video where this can be used to track weekly, monthly, and / or yearly Attendance and leaves
Also, I would be happy if you could make a video lesson on a randomizer tool for transactional monitoring that i manage as an Quality Analyst / Auditor, thanks
I have two videos on this topic please watch
Great ---video .....need "search " and "Delete" option as well.
Thanks Fahim
Very useful video I like it and thank you for it. when I select the save button and right click the assign macro has not ON. Kindly guide.
Thank you very much... I have a question... when I press the button to save what I entered remains in Data entery form ... Must then press reset until I can re-enter ...
So many thanks , i dont understand Indian language , i follow your video and understand up to min 19:39 then i dont understand your language about how make system save in new raw with using realtive buttoun
Thanks a lot
Excellent ❤️❤️❤️❤️❤️❤️❤️
Thanks
Very good. Useful video
Thanks
Thanks brother, I got more...
Thanks a lot 🙏
Nice video..god bless..sir
Thanks
Hello Bro, Your tutorial is very helpful. Today i succeed in making this thing..
But please help me more, please tell me how to do Session wise or Yearly entry using that same software. Besides please tell me how to make Automatic move cursor to next box by pressing ENTER key in keyboard.
Masha allah. Good explaining
Thanks a lot
sir meiny 500 entry Bina form ko banaye bhar Diya hy lekin bohot time lagta hy, kya aab 501 sy ya aadha sy ye form ka istamal kar saktey hy Bina aagy ka data erase kiye huwy.(kya bij meinsy form option ky jariya data dal dal sakty hy
Thanks sir very nice
Thanks
Dear sir,
Aapka data entry form aur method bahot hi achchha hai.ab muje isme calendar add karna hai to kaise kare.bas itna batane ki kripa kare.ya ek naya video bana de.
Thanks.
Ok Nitin and thanks for watching
Bahut badiya samajaya
Thanks
Great teacher❤❤
Thanks for your lovely comment
When selecting in the qualification field, numbers are shown instead of matric entry.
Thanks
Can we activate in the form sheet "TAB Button Activation" so that while filling out the form we do not need to use the mouse repeatedly?
Excellent زبردست
Thank you so much
Excellent. Thanks for sharing.
I have couple of queries...
1. How to retrieve previous entered values
2. How to delete entered values.
It is possible only with VBA coding
@@PowerExbyJitendra is it possible to share how to do that?
Thank you bro 🙏🙏
Welcome Shubham
thanks
Amazing
sir new entry 1st pr lane k lye macro ⏺️ krtr waqt kya krna hoga plz tell me kindly
Very good Sir 🎉
Thanks 🙏
I have a doubt regarding this video, how can we go to next cells(Gender,Qualification,City,State,Country) without using mouse. and using Tab or another keyboard key. Using mouse every time to go to next cell it will take time can we do it without mouse????
I want a data entry form for my housing societ charges corresponding to month wise entry corresponding to different flat nos. Please help me.
Thanks bro
Welcome
THANKS
Welcome
Excellent
Thanks
Great tutorial. Can you make a video with english sub? Thank you
Thanks bro
thanks sir
Thanks
i badly need this but i cant understand the language. is there any CC for english or transaltion for english on this one. thank you
I want to move the cursor between each text field by pressing Tab or Enter. Can anyone help?
Again sheet ko open karny or data entry karny k liye micro recording start karna pary ga??
Plz explain that how we will search record. I mean after clear the record if I want previous record. How it will possible?
Sir ji Developer mine insert par click kar activex control par click kar ke jab drag karte hai to ek error aata hai .. ovject not insert plz help sab kar ke dekh liya re install bhi mere pass office 2007 hai plz help
Sir, can you provide link to download automated form to maintain data for multiple shops, multiple items in Google sheets
Super sir
Thanks
Good work sir
Thanks
EXCELLENT JOB BUT 1 REQUEST THAT HOW CAN WE TRANFER AOUTMATICELY TRANFER THE DATA FROM DAT BASE TO OTHER 34 SHEETS OR MY QUETION IS WHEN WE WILL FILL THE FORM DATA WILL BE SAVE ON MASTER SHEET ONLY HOW WILL BE QUALIFICATION WISE SHEETS GET THIS DATA
Bro reset button ki koi need nh agar aap save optiion ke sath hi delete entries ko bhi Micro1 me add ker detey to bhi sahi tha aap ne duplicate entry stop kerney ka option bhi add nh kya...
In Access this is very easy
Excellent ----'''hoeche vdo ta
But seser diker pratekta option gulo kaacher zoom kore dekhale r o valo hobe --'''👍👍👍👍
Thank you so much❤
Sir aik bat pochni yh form jab bn Jay pur name box Mai type k bad next box Mai kasy jay gy type krny. Mouse say click krk jab Enter ya koe aor key use krk . Form bna Lea Mai ny lkn Enter/tap sb use kr leay next box Mai ni jata mouse use krna. Parta mjy plz help
WONDERFUL WORK. TRUELY GREAT CONTRIBUTION FOR LEARNERS. THANKS. BTW HOW TO LINK " PLACE" WITH "STATE" IF I HAVE BOTH LISTS? PLEASE ENLIGHTEN MEN.
Sir
Agar mouse use nahi hare to only enter key and tab key kese use kr sakte h
Great
Thanks
Nice video. I tried this but when I input a new set of data, it doesn't record them on a new row in the 'Database' sheet, rather, it replaces the previous data. Please how can I resolve this? Thank you.
Sir please use the option of 'Use Relative References' while recording macro as it is explained in the video. It will work properly.
Thanks for watching
The solution is in the step in which you place the cursor in a empty cell and column adjacent to the table that will be filled in by the data.
The Mistake you make is to immediately press on cell A1 (in the table that will then be filled in) and then do [ctrl and key down] + next steps.... While the author of the video shows that you must first position yourself on a column that will not be filled with data! So it runs the mechasnism that allows to identify the last filled row and write under it (instead of overwriting the row as you do).
@@censored8248 this work is very simple
but when you are learn complete advance excel
I do this work with the help of VBA code then this work very easy
so learn advance excel
I am currently learn C programming language and Java language
Sir aise me database me koi correction karna ho tab use form me kaise edit and save karenge? Please wo bhi describe kijiye
Can you please share the full video how you created drop downs and form box
Sir can you show me from starting towards this form , how do we create a form towards payroll data towards employee
lets suppose if we want to delete the entry , give the solution
Hallo Sir , i do not find =if in my Excel please help me
Nice video. Tab button se dusre box me kaise jayenge. Kyunki tab button kam nahi kar raha.
Wonderful But while assigning Macros in Database Sheet only 1 entry is showing which we have saved.
After reset we are adding new entry and save then then old entry is not available in database sheet only new entry is reflecting
Because he don't insert one row that's the reason ok?
What would be the resolution plz help
sir how to toggle between data entry column using TAB button, instead to clicking each column
I have also same doubt, Using mouse will take time
👍🏻👍🏻
🙏
Genius
Thanks
❤️
Can I put formula in text box
R/Sir kindly add, update search, photo uploaded, option insert in the form 🙏
Save data ko hum phir search karsakty hai jub entry zyada ho jae
👍
Thanks
but why mine is bringing invalid link, its not working at all