EASILY Make an Automated Data Entry Form in Excel

Подписаться 527 тыс.

Просмотров 291 тыс.

50% 1

Make an automated data entry form in Excel.
🔥 Take our VBA & Macros Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this tutorial you'll learn how to make an automated data entry form in Excel where you can add values, checkboxes, dropdowns, and even popups depending on your answer. Once a user clicks submit, the data automatically gets collected in a separate worksheet with a database. First we'll go over how to format the Excel file to look like a form, then we'll go over how to create the results sheet, followed by how to automate the whole process, and finally how to protect the Excel sheet so other users don't break it.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Format Data Entry Form
5:42 - Store Submitted Results
8:18 - Automate Data Entry Form
12:44 - Protect the Form

Опубликовано:

20 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 177

@KenjiExplains Месяц назад

🔥 Take our VBA & Macros Course: www.careerprinciples.com/courses/vba-macros-for-business-automation

@amcytechresource9607 Месяц назад

This is my first time watching your video and i found you do amazing while watching. Clear, direct, detailed and concised.

@Dr-Luvaz25 Месяц назад

Thank you Kenji I enjoyed this video as I was working with you , You're the best keep up the good work. all the way from South Africa

@wrickeynelson9689 Месяц назад

Thanks Kenji, you make my work life easier with this. Well explained and have change a lot of my data entry .

@Chrisdb851 Месяц назад

Thank you for simplifying this process

@John-sl8cs 28 дней назад

Kenji - you are a genius. Thank you!!!!

@donaldmacdonald4901 Месяц назад

Thanks Kenji much appreciated as always

@iamLorenzoChatmon 29 дней назад

This was a very useful video. Thank you for creating it.

@droidfan Месяц назад

The automation section was great! I never would have thought about that! Thank you!

@usamashakeel2833 Месяц назад

This is good when you have 15 or less questions What about if you have 350 questions data entery of 500 respondents 😅. Sadly, i wish my professor use Google form.

@swapnilshingwekar7359 Месяц назад

Your post are very simple and concise to understand

@AZ4ZEL666 15 дней назад

THANK YOU Its easy to understand with your good explanation

@isdfkjhgd11 Месяц назад

This is so helpful!!! thank you so much for uploading this!!! subscribed! 🙏

@erikguzik8204 26 дней назад

nice video. Couple things you should change, in the protection tab, don't allow selection of protected cells, this way the cursor stays only in the cells the are unprotected, so it works more like a user form where you can't select the titles. you also need to unprotect the refers to cell for the Option buttons. The option buttons are trying to change a value in a protected cells. this is why you get the error message.

@abdullahadam6187 Месяц назад

Easy to understand, thank you ❤

@jeffreyguevarra3000 Месяц назад

Very helpful and easy to follow. Kudos!

@stevejn1444 9 дней назад

great presentation - easy to follow and helpful!

@SergMarAlamo Месяц назад

excelent explanation, thanks Kenji

@Luciano_mp Месяц назад

Very good, useful! Thank you.

@royalsolutions7684 Месяц назад

Thanks a lot for this amazing tutorial. Never knew Excel was so powerful .

@KenjiExplains Месяц назад

Glad it was helpful!

@power-reconcile Месяц назад

Well explained and thanks for sharing!

@user-ol2yh6ob6j Месяц назад

Great video, you make learning looks easy.

@geovannyolivero6241 Месяц назад

Kenji, just to let you know that You are the Best. Outstanding video

@KenjiExplains Месяц назад

Thanks so much 😁

@carlospulidofalcon5656 Месяц назад

'm literally watching you while having lunch. Thanks for the entertainment/learning video.

@KenjiExplains Месяц назад

Nice! Hope lunch is a good one haha

@norizaamin9028 24 дня назад

Thank you sir. Your instructions are very easy to follow. I was able to automate my library book stocks. I currently in planning of using excel to automate a library lending system.

@olamikekanishola6410 10 дней назад

what a fantastic presentation. Thank you

@motivateme3244 18 дней назад

guy you did so well, i love the video it's understandable

@drumswithmatt Месяц назад

Thank you for this excellent video

@shermilabdul1 9 дней назад

Thanks, you are a lifesaver !!

@abdulrahman-qg3sh Месяц назад

Sir please make such kind of videos on Power BI But you are making excellent videos on excek ❤❤

@modupeolupona2668 3 дня назад

You're a genius! Thanks for making this video just when I needed it

@heshamabuzaid4293 24 дня назад

Thanks you so much, it was really clear and valuable.

@dany-hermannkouassi8987 Месяц назад

Great! We always learn something new with you. But here is an other way to generate a form more easily by creating the data array first then select a cell in the array and in the search console, Search for the function "form ". Excel will show a you a form based on the informations in the first row. However this video allows us to learn more functions. My methode is for lazy persons 😂.

@brandon.T1531 20 дней назад

Thank you for the video! I would like to suggest a slight alteration to the process. 8:05 - You could omit the need to transpose (and by proxy, the "Raw" sheet) by moving the refence cells (C21:D30) to the top of the Data tab as a single row instead of as a column on the input sheet. Then, you could paste directly to a table on the same page using your process.

@lalchhanhima_DarkHeart 15 дней назад

Yup, ikr?

@worldwiderich93007 18 дней назад

Thank you Kenji... It is very good Video. Its save lots of Time.

@vaaileen227 9 дней назад

thank you for this tutorial.

@kevf2720 16 дней назад

Very informative. I have a few ideas for work that I will try this with.

@maxwelnoa6292 6 часов назад

Man you just amazing thank you bro

@nishanth4323 Месяц назад

👏🏻👏🏻👏🏻 wow awesome explanation and good very easy to understand for new Learner's

@maher_a._alzoubi Месяц назад

thank you so much for everything 🙂

@ActiveLearningforAll 9 дней назад

Interesting lession. Thanks

@putrakamangpu5033 Месяц назад

Thank you, I have a lot to learn here..

@marwanattya8067 Месяц назад

Simple and great 👍

@SandeepSharma-md2ex Месяц назад

Amazing way of teaching

@KenjiExplains Месяц назад

Thank you for your comment :)

@FRANELC-ss8sz Месяц назад

SUPER BROO NOW I DONE THIS AUTOMATION WORKS REALLY GOOD THAN U 😍😍

@ajayshivpuje3797 Месяц назад

Sir your videos are very useful. Please make videos on Power bi

@leonidhammer4897 10 дней назад

thats fire! thanks!

@christiangarcia3795 Месяц назад

Great video. I wonder if the submitted data could feed a dinamic table as well.

@i-jamesazubuike9208 26 дней назад

Very great and inspiring! Thànk a lot❤

@PreachKreachh Месяц назад

Brill Vid, learnt a lot

@yichamroeun3948 17 дней назад

Very nice and useful.

@kasm.pasaulan9672 Месяц назад

Thanks Kenji for this work. I would like to know if I can do the same macro for "update" as "submit" to update the data.

@camlex6310 Месяц назад

Wow really great!!

@PsycheKane Месяц назад

Hi Kenji thanks for the video. I wanted to add that a solution to correcting the form buttons is by right clicking and going to format control, you will see an option tab for protection. Once you uncheck the "locked" option, it will allow the user to select the button even when the sheet is in a protected state.

@Linda-jo8ys 29 дней назад

Mine doesn't work

@heydeeeguia8421 2 дня назад

As an HR practitioner, I find this tutorial very important for us. Reporting and system entry are not my strong points, so I am trying to improve through online learning. Thank you for this video. I plan to create a similar data entry format for performance reviews and recruitment. Could you please send me a similar link, as well as information on printing the final product? Thank you very much.

@savezabbasi9733 Месяц назад

Awesome 🤩

@ianrobertson5128 Месяц назад

Great Video. Ensure the cell link for the two radio buttons is unlocked before you lock the sheet. It should work after that.

@sabeelahmed1157 Месяц назад

Even I had the same thought

@amcytechresource9607 Месяц назад

very well noted

@andrea_weekenduae6058 Месяц назад

Nice video! Is there a way to have a message if some fields have already been inputted previously to not create a duplicate?

@Rocky-md7ib 8 дней назад

Nice interpretation

@katgrey6239 13 дней назад

Very interesting 👌

@jaimemoran5428 Месяц назад

Espectacular @KenjiExplains !!

@ancc1969 18 дней назад

Hi Kenji, thank you for all your excel tutorials. Can I trouble you to consider showing your viewers how to do a dashboard that tracks monthly dividends?

@shweta-bisht Месяц назад

Loved it 💕💕💕💕

@KenjiExplains Месяц назад

Thank you!

@jayvinbonajos3855 Месяц назад

Hi Kenji, I'm always watching your videos! Thank you for this tutorial. By the way, could I request an inventory management system in Excel? It will be used for a hotel and casino business. Thanks!

@mghargrave2863 26 дней назад

When hiding information that is off the end of the intended user work area it's generally more secure and less prone to data corruption to hide the rows and columns rather than match the colour.

@rawconcept 19 дней назад

yeah right, but as long as the sheet is protected with the cells locked, making only your intended work area active, then your data remains intact...

@zakimo458 8 часов назад

Thank u dear

@einoconsult5563 Месяц назад

Great content, can we do the same with Office Script

@mestosabinov08301 23 дня назад

perfect video I have a question in the "form" you have the item "Staff ID" how is it possible to make the "Staff ID" value so that I don't have to enter it manually, but it would always be new with a new record example: first staff value 1 second staff value 2 etc... something like n+1 always on a new record

@rafayhussain4171 Месяц назад

I am doing acca now on what skills I need to build my career previously I had Excel knowledge

@franciscoeiras3711 Месяц назад

You only need to unprotect the cell where you link the option buttons, in this case E27. After you do that it will work

@williamwedding5317 Месяц назад

Thanks!

@KenjiExplains Месяц назад

Thank you for your support!

@desilvakts2071 Месяц назад

Hi Kenji, in the macro where the data gets copied while the previous data move down, instead of this how can i do it so that new data gets added to the immediate row and continue to add to the rows below.

@kimmcmahon4440 3 дня назад

Thanks for the video. How do we share the form with others?

@optimistjourney2024 25 дней назад

Thanks

@twiitedululeninakweenda9839 7 дней назад

Thank you Kenji for a wonderful tutorial. Just a quick question under Dietary Restrictions: When I inserted the Formula in case the Answer is a "Yes", if one opts for a "No", then it also indicates a "False" just below it. How do I correct that please?

@paulabrink1532 Месяц назад

Hey Kenji, Great video! Got lots of answers here. Do you have any ideas on this: We have trainers that need to tell us where in the world they will be training. From date - To date, Country, and Time Zone. I will want to plot that on Excel. I think this form idea of yours is going to be great - so my question: How can I use the 2 dates - from and to - to populate themselves in a grid so that we can see all the dates in between as well??

@Esgala2024 25 дней назад

what if i want to change the look of the responses page of the excel sheet? i want it to look like a decently looking document that i can print that has headers and footers and a company logo for example. Can i specify what cell is it going to insert the data inputted from the form?

@drumswithmatt Месяц назад

Sir could please make a video for school payments automation per student?

@jaywindross6693 Месяц назад

Thanks Kenji, great video to follow! How would we stop the 2 other tabs (Data and Raw) from being viewable as there could be sensible information on there?

@Linda-jo8ys 29 дней назад

Hide the sheets. Right lick on each sheet(Data and Raw) , you will see the option to Hide. To unhide them, right click on the Form or any unhidden sheet: it will show you all hidden sheets and you will be able to unhide them from there

@fssacko Месяц назад

Great thank you lot Mr Kenji

@miksosnowy1038 19 дней назад

interesting video. just why to format 1mln rows for such small form?

@davidchow923 Месяц назад

Hi Kenji, why the second time that I type a serise of data, it can follow the previous one and will not be replaced? Please let me know. Thanks.

@rams14370 День назад

could you please provide a one on one session (online) on advance excel and vba macros. I am from india.

@erick.terrestrial Месяц назад

You have to go to format settings on the checkboxes and unlocks them, and enable auto filters when you protect the sheet

@pizmen24 Месяц назад

how will we send out the form? without the data and other sheets. I think it is not possible. but nice learning vid

@muhammad__nouri Месяц назад

Great

@user-ly3ox7rc1d Месяц назад

Hi kenij sir, i'm rimon from bangladesh and learn excel video to your channel,You are very interisting now i want to your help. i want an best data analyst please suggest your opinion

@investorritel5298 15 дней назад

Sir, please make about stock market❤❤

@shafiqulsymon5482 Месяц назад

Hello , If I want to edit my previous entry after clicking the submit button, how can I do it?

@milanmmng 24 дня назад

Bravo

@entrustedhub Месяц назад

What causes my micro to shake, sometimes freeze until I switch off my computer? Thank you

@aboapid 24 дня назад

Is there a way to choose cells shift up ؟

@JustinHorrocks-vh3em 25 дней назад

I added a date field to track date of entry and it's not reflecting correctly in the Data Tab. Any guidance?

@danielsomera9396 28 дней назад

Can this work in iPads?

@jeffgeneo Месяц назад

Can you run this in excel web?

@user-uf1yn4wg9d 19 дней назад

thanks for that but how can i refound it after that

@kushangshah-be7hn 25 дней назад

can i do all this on website excel? I don't have inbuilt application.

@garmrdmr 28 дней назад

Not sure if anyone answered - but to protect the check boxes: i grouped them then selected the group and dbl clicked Format shape window comes up on the right of the page. select the third set of settings - select the "locked" option finally protect the sheet as Kenji did. now the options can be selected /changed but they cannot be select for editing