Fully Automated Data Entry User Form in Excel | No VBA

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

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

[@inoxentmen]

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

[@PowerExbyJitendra]

Thanks a lot

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

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

[@ashwinibendre8674]

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

[@PowerExbyJitendra]

धन्यवाद

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

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

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

[@zaibgraphics7294]

I learned well after seeing 2 times thanks

[@PowerExbyJitendra]

Welcome

[@zaibgraphics7294]

@@PowerExbyJitendra sir pic ka button kaisy add karengy please

[@SurveyorAmeerAbbas]

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

[@PowerExbyJitendra]

Thanks

[@fahimreza1377]

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

[@PowerExbyJitendra]

Thanks Fahim

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

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

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

[@rajivmanamperi7628]

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

[@Hassan5541-s4r]

Great teacher❤❤

[@PowerExbyJitendra]

Thanks for your lovely comment

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

[@Vijay_Vipra73]

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

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

[@TanwirMughal-b5o]

Excellent. very useful.

[@mirzabilal3508]

MashahAllah Behtreen

[@pareshpatel1762]

Very good Sir 🎉

[@PowerExbyJitendra]

Thanks 🙏

[@shashisharma9366]

I followed your instructions to o good

[@Hassan5541-s4r]

Beautiful Entry Form

[@ravindra1206]

Bahut badiya samajaya

[@PowerExbyJitendra]

Thanks

[@samirmukherjee6375]

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

[@PowerExbyJitendra]

Thank you so much❤

[@zakirfaza6856]

Masha allah. Good explaining

[@PowerExbyJitendra]

Thanks a lot

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

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

Very Good tutorial.

[@qarikhurramshahzadhashmish7725]

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

[@aliroshan16]

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

[@pramodsharma1938]

Shandar tutorial

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

[@sreenivas165]

Very good. Useful video

[@PowerExbyJitendra]

Thanks

[@dinushirathnayake6138]

Thanks brother, I got more...

[@PowerExbyJitendra]

Thanks a lot 🙏

[@krantikachkure9785]

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

[@PowerExbyJitendra]

Thank you so much😊

[@chesscube_azhar]

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

[@msi________2760]

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

[@PowerExbyJitendra]

Thanks

[@KrisShaunAque]

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

[@PowerExbyJitendra]

Thanks bro

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

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

[@ravisen927]

Thanks sir bahuy helpfull he thanks

[@jackalloothara]

Well narrated. Great

[@PowerExbyJitendra]

Thanks

[@learncomputerapplication5156]

Wonderful. Thankyou so much for making an excellent video.

[@PowerExbyJitendra]

Thanks🙏

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

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

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

[@ru915]

very nice 👍

[@PowerExbyJitendra]

Thanks

[@tallyerptutorials]

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

[@shailendraaswal6075]

Nice video..god bless..sir

[@PowerExbyJitendra]

Thanks

[@golamsorwar6685]

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

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

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

[@vandanamanik4148]

Excellent

[@PowerExbyJitendra]

Thanks

[@candyfloss2307]

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

[@pundalikshendure40]

Good work sir

[@PowerExbyJitendra]

Thanks

[@mussietesfazghi2102]

Thank you so much

[@nekkantiramamurthy2351]

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

[@mohammadilyas2260]

Excellent زبردست

[@PowerExbyJitendra]

Thank you so much

[@Kssp-lv9uk]

Super sir

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

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

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

[@TheSafetySpot]

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

[@dibbasandeep5822]

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

[@kumarrakesh529]

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

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

[@shakeel447]

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

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

[@raheemkhan4083]

Thanks sir very nice

[@PowerExbyJitendra]

Thanks

[@tapanmishra3051]

In Access this is very easy

[@sandeepgupta6526]

Thanks

[@zubairakram114]

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

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

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

[@neetishkumar9185]

Sir
Agar mouse use nahi hare to only enter key and tab key kese use kr sakte h

[@pawanjamal]

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

[@jawadmalik4350]

lets suppose if we want to delete the entry , give the solution

[@MuzamailMuzamail-y3g]

Thanks bro

[@PowerExbyJitendra]

Welcome

[@sarala_devil]

Can I put formula in text box

[@vaibhavdange2242]

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

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

[@ashishsaxena356]

Very well this video😅😅

[@PowerExbyJitendra]

Thanks a lot

[@abhijeetprakashraosonwane8576]

thanks sir

[@PowerExbyJitendra]

Thanks

[@zaryabinfotech500]

Sir ye WPS office mein mobile Sy ho skta hy ya ni ho skta entry form

[@PowerExbyJitendra]

Nahi ji

[@zaryabinfotech500]

Laptop par Hoga ya computer par

[@PowerExbyJitendra]

Both

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

[@SehrawatFitHealth]

Amazing

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

[@tanzirhossen918]

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

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

[@satishkulkarni3402]

Great

[@PowerExbyJitendra]

Thanks

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

[@godsatyamop6633]

THANKS

[@PowerExbyJitendra]

Welcome

[@gautamrajbongshi9963]

How to convert data into form automatically... Is there any solution

[@rajeshchoudhary2520]

Nice Video, But new entry form bhrne ke baad me save krte hi next entry ke liye pahle baar-2 reset krna pdta hai, to Sir ji baar-2 asaa na ho, new entry form complete bharke save krte ki starting se apne-aap blank ho jaaye aur turant hi new entry form bhrna chalu kre, to please asa video bataiye

[@PowerExbyJitendra]

Yes Rajesh I am thinking about it.