Fully Automated Data Entry User Form in Excel | No VBA

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.c...
==============================
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/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

[@SonuRaj-zp8ik]

Aap mey ek quality ha aur wo ye k
Aap bohat ache se dhere dhere samjhate hai. Many many thanks🙏.
God bless you🙏🙏🙏

[@shariqmqureshi]

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

[@deepikatanwar1813]

I'm not interested before the video but now I'm interested to learn, very well explain keep going good luck

[@inoxentmen]

Mashalllah Good Job Apka Samjhane ka tareeqa Bohat Hi acha ha keep it up

[@PowerExbyJitendra]

Thanks a lot

[@nasirao786]

Thanks you Boss I enjoy this letacher. Good letacher. ALLAH ap ko Khush rkhy Ameen. I am in Pakistani.

[@PowerExbyJitendra]

Thanks for your beautiful words.

[@priyamahato5761]

bahut acha bataya sir apne or ish tarah ke vedio banaye sir 🙏🙏🙏🙏🙏🙏🙏

[@PowerExbyJitendra]

Thank you so much

[@abhishektiwari2643]

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

[@kumarthiyagarajan6724]

Formula cruise trineein neet

[@saeedkhan9538]

Very good lesson. I have learned a lot. And I appreciate your patience.

[@worldmemes11]

Thank you sir jitendra very helpful video and today i learn new think about excel alot of thanks 🥰🥰

[@PowerExbyJitendra]

Thanks Bhai

[@FalconGamers_FG]

@@PowerExbyJitendra bro how to use tab while making data entries?

[@ashwinibendre8674]

बहुत बढ़िया समझाया आपने
धन्यवाद भैया🙏

[@PowerExbyJitendra]

धन्यवाद

[@whitedove6878]

Dear Sir Jitendra very professionally explained step by step and very slowly for students to follow and grasp in mind. I salute to you

[@PowerExbyJitendra]

Thank you so much bhai

[@zaibgraphics7294]

I learned well after seeing 2 times thanks

[@PowerExbyJitendra]

Welcome

[@zaibgraphics7294]

@@PowerExbyJitendra sir pic ka button kaisy add karengy please

[@streethawksmotorcyclesjawa1269]

thank you bro, this video is awesome to everyone and you are great.

[@stevedhiwar]

Very simple and easy method I will try

[@PowerExbyJitendra]

Thanks a lot

[@mirzabilal3508]

MashahAllah Behtreen

[@Jojosmith342]

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.

[@PowerExbyJitendra]

Thank you so much

[@Jojosmith342]

@@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.

[@Jojosmith342]

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

[@Jojosmith342]

@@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

[@TanwirMughal-b5o]

Excellent. very useful.

[@shashisharma9366]

I followed your instructions to o good

[@pramodsharma1938]

Shandar tutorial

[@ravindra1206]

Bahut badiya samajaya

[@PowerExbyJitendra]

Thanks

[@Hassan5541-s4r]

Beautiful Entry Form

[@পড়ালেখা০১]

Very Good tutorial.

[@pareshpatel1762]

Very good Sir 🎉

[@PowerExbyJitendra]

Thanks 🙏

[@SurveyorAmeerAbbas]

I am very happy to learn the lesson ☺️ Thanks Dear sir

[@PowerExbyJitendra]

Thanks

[@Hassan5541-s4r]

Great teacher❤❤

[@PowerExbyJitendra]

Thanks for your lovely comment

[@sreenivas165]

Very good. Useful video

[@PowerExbyJitendra]

Thanks

[@ravisen927]

Thanks sir bahuy helpfull he thanks

[@nitinsapariya8858]

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.

[@PowerExbyJitendra]

Ok Nitin and thanks for watching

[@dinushirathnayake6138]

Thanks brother, I got more...

[@PowerExbyJitendra]

Thanks a lot 🙏

[@zakirfaza6856]

Masha allah. Good explaining

[@PowerExbyJitendra]

Thanks a lot

[@samirmukherjee6375]

Excellent ----'''hoeche vdo ta
But seser diker pratekta option gulo kaacher zoom kore dekhale r o valo hobe --'''👍👍👍👍

[@PowerExbyJitendra]

Thank you so much❤

[@Vijay_Vipra73]

Nice👌👌 but form should be cleared on clicking the save button only.

[@fahimreza1377]

Great ---video .....need "search " and "Delete" option as well.

[@PowerExbyJitendra]

Thanks Fahim

[@msi________2760]

Excellent ❤️❤️❤️❤️❤️❤️❤️

[@PowerExbyJitendra]

Thanks

[@hatemraouby5267]

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

[@PowerExbyJitendra]

Thanks a lot

[@mussietesfazghi2102]

Thank you so much

[@damojipurapuseshagirirao4346]

Excellent. Thanks for sharing.
I have couple of queries...
1. How to retrieve previous entered values
2. How to delete entered values.

[@PowerExbyJitendra]

It is possible only with VBA coding

[@damojipurapuseshagirirao4346]

@@PowerExbyJitendra is it possible to share how to do that?

[@ru915]

very nice 👍

[@PowerExbyJitendra]

Thanks

[@krantikachkure9785]

great..thank u for sharing such wonderful knowledge😊😊😊

[@PowerExbyJitendra]

Thank you so much😊

[@chaihtetlangcabin]

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.

[@chesscube_azhar]

Really the great explanation, try how to use it in mobile

[@rajivmanamperi7628]

Excellent Video. thanks so much. Let me know how to search, modify & delete the existing data using the combo buttons.

[@vandanamanik4148]

Excellent

[@PowerExbyJitendra]

Thanks

[@sandeepgupta6526]

Thanks

[@pundalikshendure40]

Good work sir

[@PowerExbyJitendra]

Thanks

[@golamsorwar6685]

I am very much happy to learn. Thank you very much dear. Take care

[@PowerExbyJitendra]

Thanks 🌹🙏

[@learncomputerapplication5156]

Wonderful. Thankyou so much for making an excellent video.

[@PowerExbyJitendra]

Thanks🙏

[@jackalloothara]

Well narrated. Great

[@PowerExbyJitendra]

Thanks

[@Kssp-lv9uk]

Super sir

[@PowerExbyJitendra]

Thanks

[@shailendraaswal6075]

Nice video..god bless..sir

[@PowerExbyJitendra]

Thanks

[@rcmackay]

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..

[@Ash-ut7of]

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.

[@tonitoni9368]

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 ...

[@tapanmishra3051]

In Access this is very easy

[@MuzamailMuzamail-y3g]

Thanks bro

[@PowerExbyJitendra]

Welcome

[@raheemkhan4083]

Thanks sir very nice

[@PowerExbyJitendra]

Thanks

[@KrisShaunAque]

Great tutorial. Can you make a video with english sub? Thank you

[@PowerExbyJitendra]

Thanks bro

[@abhijeetprakashraosonwane8576]

thanks sir

[@PowerExbyJitendra]

Thanks

[@mohammadilyas2260]

Excellent زبردست

[@PowerExbyJitendra]

Thank you so much

[@Adiosamigos12345]

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

[@satishkulkarni3402]

Great

[@PowerExbyJitendra]

Thanks

[@ashishsaxena356]

Very well this video😅😅

[@PowerExbyJitendra]

Thanks a lot

[@tallyerptutorials]

Sir, can you provide link to download automated form to maintain data for multiple shops, multiple items in Google sheets

[@SehrawatFitHealth]

Amazing

[@godsatyamop6633]

THANKS

[@PowerExbyJitendra]

Welcome

[@AROUNDTHEWORLD-dx1bl]

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

[@candyfloss2307]

Can you please share the full video how you created drop downs and form box

[@lychanda809]

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

[@jawwadajmalkhan6249]

Genius

[@PowerExbyJitendra]

Thanks

[@azizkhan-dw5fh]

Nice videos. thanks for such informative videos. I am a beginner for excel. i also have some queries. if you please help

[@romaanhameed2789]

👍🏻👍🏻

[@PowerExbyJitendra]

🙏

[@Together4Paws]

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?

[@Adiosamigos12345]

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

[@PowerExbyJitendra]

I have two videos on this topic please watch

[@qarikhurramshahzadhashmish7725]

sir new entry 1st pr lane k lye macro ⏺️ krtr waqt kya krna hoga plz tell me kindly

[@maegarage3318]

Hi i try copy like you do, but i have question where when u want to do recording the macros, there one thing when u want to paste, before that you go to I column, and after that what you press until you suddenly go to row 1048576, can u show me how exactly need to do, which button need to press? pleasure you respond my question, due to not quite understand yet

[@PowerExbyJitendra]

This is necessary for pasting data in the appropriate row.

[@aliroshan16]

Again sheet ko open karny or data entry karny k liye micro recording start karna pary ga??

[@kumarrakesh529]

Nice video. Tab button se dusre box me kaise jayenge. Kyunki tab button kam nahi kar raha.

[@ta20111996]

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...

[@rasanraji3677]

👍

[@PowerExbyJitendra]

Thanks

[@dr.jiwankumar6557]

Sir aise me database me koi correction karna ho tab use form me kaise edit and save karenge? Please wo bhi describe kijiye

[@ironpanda1157]

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

[@shakeel447]

Plz explain that how we will search record. I mean after clear the record if I want previous record. How it will possible?

[@TheSafetySpot]

Save data ko hum phir search karsakty hai jub entry zyada ho jae

[@MANAVSARKAR-jc9kp]

well

[@PowerExbyJitendra]

Thanks

[@nekkantiramamurthy2351]

Sir can you show me from starting towards this form , how do we create a form towards payroll data towards employee

[@sathishrna4270]

❤️

[@manojpatnaik63]

I want a data entry form for my housing societ charges corresponding to month wise entry corresponding to different flat nos. Please help me.

[@stevedhiwar]

I am using windows 7 professional I dont have assign micro when I right click suggest any other option

[@PowerExbyJitendra]

You have an older version . Macro is available in 2010 and upper versions.

[@eugenemeenan3703]

a macro is VBA so really you are creating a form with a Macro. Shame was hoping you'd have found the holy grail on form input in excel - but still a good method.

[@PowerExbyJitendra]

You are right bro

[@dibbasandeep5822]

Sir after creating this form and database sheets , can we use this in mobile version excel sheet?

[@zubairakram114]

When selecting in the qualification field, numbers are shown instead of matric entry.

[@sarala_devil]

Can I put formula in text box

[@vaibhavdange2242]

Sir is form me search button kaise add kre... plz

[@aniekpenobassey7554]

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.

[@PowerExbyJitendra]

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

[@censored8248]

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).

[@abhishektiwari2643]

​@@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

[@Teck-Trending]

ky aap hotel management ke liye ek video bana sakte hain without VBA

[@PowerExbyJitendra]

I will try it is already in my mind

[@Teck-Trending]

@@PowerExbyJitendra thank u

[@aravindbiology]

WONDERFUL WORK. TRUELY GREAT CONTRIBUTION FOR LEARNERS. THANKS. BTW HOW TO LINK " PLACE" WITH "STATE" IF I HAVE BOTH LISTS? PLEASE ENLIGHTEN MEN.

[@sairamvinodula9426]

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????

[@mayankkarodiwal7884]

sir how to toggle between data entry column using TAB button, instead to clicking each column

[@sairamvinodula9426]

I have also same doubt, Using mouse will take time

[@RTimo]

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

[@tanzirhossen918]

I want to move the cursor between each text field by pressing Tab or Enter. Can anyone help?

[@ameetvarma5530]

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

[@felixdelarosa9266]

Because he don't insert one row that's the reason ok?

[@ameetvarma5530]

What would be the resolution plz help