Idiot-Proof Excel - 5 - Save Data from a Form

[@sabrinamimouni8306]

I set the form to" = blank" intuitively after a successful data entry before the end of the video 🤓 Thank you so much for the logic behind this tutorial !!!! You're the Excel king for sure!!!!

[@hehebeaujoy]

This is a great tutorial. Easy to follow, even for beginners. Thank you so much and please keep doing what you are doing!

[@carsongeib]

Question - can this form be saved in a MS Teams file location and be used collaboratively? I am looking for an effective way to capture manufacturing shop floor data from multiple areas in a consistent format, and move away from current method of folks filling out paper forms, scanning them in, and not having any way to search for that data. No OCR scanners here, and unfortunately people forget to scan papers in all the time anyways. So far, I've confirmed that I can open the Excel file from a MS Teams file location, hit the submit button, and the data is there. However, it seems to start having issues or act funky when I have another person open the file simultaneously and try to enter data. We are opening it from the Excel app, not the Teams Excel viewer. Thanks for these videos, they've been extremely helpful in getting me a working form. Really appreciate it! Liked and subscribed.

[@Mlamas2]

Love this series. It has been very helpful. Clear and simple instructions. If the premium content equals or exceed this quality, then go for it.

[@TeachExcel]

Glad to help, and thanks a lot! The premium one is actually now up and you can check it out here: www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel

[@bundubashing2591]

@@TeachExcel do you have the same course for Excel Online Office Scripts?

[@federicodelcastillo1369]

Hi, I’m getting an error 1004 when I hit Submit I think It’s referring to End(x1Up)

[@AndrewSmith-vv7vh]

Thanks once again. You make things so easy to understand.

[@TeachExcel]

You're welcome! I'm really glad you think so:)

[@arduinoguru7233]

Great work.

[@tigercrane100]

Unfortunately getting a Compile error. It would have been nice to show the step where you added the Store_Data module.

[@JohnSmith-yn7jz]

I'm thinking that you have one of the biggest brains in the world!! These tutorials are amazing. Thank you! I know that you prefer whiting out the page to hide the contents, but custom format with ;;; hides the contents with no color (so even if you change the colors, etc. it will be hidden). I'm sure that you could add extra value for more personalized, premium commentary.

[@shridharan]

Did we get id data and name interchanged while submitting ? (may be you have already noticed)

[@truckerdaddy-akajohninqueb4793]

You inserted name into id and id into name. But I can fix that

[@TeachExcel]

This sounds like a mistake I would make haha

[@truckerdaddy-akajohninqueb4793]

@@TeachExcel Did you ever play with Clarisworks. Mac. I used to make forms in Clarisworks. It had a spreadsheet component. And you could merge it into the word processor too. Recently I've been playing with Google forms. I'm going to have a go at this too. Covid has prevented me from passing out paper quizzes. Thanks for the video.

[@countrymagic61]

This is an awesome video series. I am still using Excel 2016. I use Excel for personal purposes as in tracking my accounts (checking, savings, credit cards, ect.) I have not found a personal home budget which suit my needs and what I want to do and how it is displayed. So, I attempt to learn what I need from awesome videos like yours. Thank you for posting. In this video on the data sheet to record the input info, the "ID" and the "Name" are not stored in their respective columns. You have the name under the "Id" column and the Id under the "Name column.

[@enkay2000]

u r too good... thanks for all the knowledge sharing

[@enricorueda7002]

i copied almost the whole thing but I got RUN-TIME ERROR 1004 (Application-defined or object defined error what could be the problem?

[@omarobando8273]

awesome videos, i'm creating something similar and this is helping TREMENDOUSLY!! you're awesome. I am interested in the premium package. I'm also looking for a code that will add (n+1) to the last set of number in a data... to have an automatic sequential number every time an entry is created. have you done anything like that?

[@chriss8474]

Thanks for the great tutorials Amigo!

[@joshsjams1]

HELP!! I wanted to create a SIMPLE spreadsheet based on your FIRST video of a "FILLABLE" form and send it to a spreadsheet. I watched EVERY video. DID ALMOST everything but the Macro's, so it was a waist of time. Is there a way to make this SIMPLER??? I just want to take info from the fillable hit submit and POOF it is in the spreadsheet. Can you do a SIMPLE video of how to do that?? PLEASE

[@kevinholley5418]

I am at part 5 in idiot proofing forms in excel. I have not fully learned about Access. But that seems like an actual database. o you cover this in your premium course, or any of the tutorials?

[@nsanerydah]

Great series. Painfully had to rewrite my forms multiple times, but finally got up to clearing the data and resetting the form. My issue is that once I clear the form, the error count function no longer works. Any ideas? Thanks again for your hard work and help.

[@PopoyTanke]

What will happen if they try to right click on the button and change the module to different one?

[@jamesparson223]

Working through the videos

[@deanneyoung2163]

Hey. I have successfully created my own form using these tutorials. Thank you for this. However, I do have a question. How do you get the data to go to different specific sheets based on one of the headings rather than one generic sheet?

[@BalefulHead]

I'm glad you went over the Offset detail. I spent days building an advanced form with a different tutorial and I believe the Offset values (for which that teacher chose the value as "-1") is one of the problems with that code. After this tutorial with you I understood enough of all the components and what they're intended to do in order to create a more dynamic and functional form (with 46 fields) that works like it's suppose to. Well done - and thank you for the taking the time.

[@TeachExcel]

You are very welcome! I'm glad you were able to get the form working well :)

[@hawsmith]

ID and name do not map properly to data worksheet in your tutorial.

[@bobprentice8326]

I think that the Premium Helper program is a great idea as it sounds like it will expand upon information that we have learned in the last 5 videos for this project and we will be able to learn about how other projects are handled. I am looking forward to joining you on those.

[@TeachExcel]

Thanks for the feedback! I'm still working on setting it up and will keep you in the loop!

[@mikecerda89]

Hello, great tutorial, question, I am receiving error code 1004 application defined or subject to find error.. I followed the tutorial step by step not sure what I'm doing wrong.. please help!

[@Thedustymichaels]

Can aminosyrer help me? When i type the submit button the VBA editor opens up, and highlights «Set sourceSheet = Sheets(«Form») - command in yellow. What do i do wrong???? I have a screenshot of it, but i can’t leave it the commentfields.

[@cherokeee6491]

I am so enjoying your tutorials!!! They are clear, precise, easy to follow and the best I have come across so far! However, I have one very minor issue with this one. I am not VBA savvy, and I could not figure out why you had two Modules and I could only see one. What I forgot from the 1st video on creating VBA was to right click on the sheet, and insert a module. It was not until the very end that I remembered. Other than that, really great tutorials! 🙂

[@janukapeiris1193]

Stupid question...I've downloaded the excel file, is the password to have a look at the code somewhere?

[@williambiter9348]

What are your feelings on Access vs Excel? Will Access survive? I heard 2019 was the last time Access will be updated.

[@waltermakuzander5248]

Your tutorial videos are very helpful. I watched almost all of them. For now I'm just interested the part saving data from the Form to another sheet by hitting the save button. Simple saving data only, no other conditional formatting like in your previous videos. Do you have a video for it? Because in this videos it also covers a bit of lesson from previous videos. I hope you could help me. Thanks and more power.

[@othmanoasri7882]

Sir , I follows you macros coding stuck at Set source_Sheet = Sheets("Form") -Why ..? follows according ly got run-time error 9

[@ahmadkhairilirham]

Excellent series for the Idiot proof forms for excel. Really enjoyed and learnt a lot. Can this form data output to a table. I have tried to execute successfully to an non table sheet. But when I formatted as table it no longer works.

[@adambrown6532]

works great. Had a couple of typos on mine but I figured it out

[@yeseniasoriano1411]

Mine didn't work! it doesn't transfer the data. No errors either???

[@jamesparson223]

Also using FORMS from Customized menu

[@sandeeptiwariALIVE]

Excellent tutoring.. 👍👍👍

[@robertloucks1592]

Sheet "Data" in columns A and B reversed

[@TeachExcel]

Thanks! I JUST noticed that yesterday when making the next ones haha. Its a quick-fix in the code and I will address it early-on in the next video. In case you don't want to wait, where the data is placed into the Data sheet in the macro, the column order goes from 2 to 1 to 3 and you just need to switch the 2 and the 1. If that's confusing, the next video clears it up.

[@Umayr207]

Hi, everything worked for me until now. When I linked the store data macro with the validation form, it didn't work when I clicked on submit. An error message referred me back to the store date macro. What shall I do?

[@saraknowles7827]

I'm getting the same thing. The error reads: "Run-time error '438': Object doesn't support this property or method." When I click Debug, the first line of data transfer code is highlighted, which for my specific worksheet is: dataSheet.Cells(nextRow, 1).Value = sourceSheet("F4").Value I’m going to run through a few other tutorials and check some forums, I’ll let you know if I find a solution (unless TeachExcel happens to respond before I figure it out.)

[@elsonjm]

@@saraknowles7827 I am getting the same thing.

[@katyro_00]

Hi! First thank you for this tutorial. I have a quetion. Is it posible to have a form in one worksheet and data in another one. I want to send this form to my colleages and I want a data to be populated as they submit the form. Data workbook would be on my computer. in short, 2 workbooks, one with form, another one with data, but conncted.

[@rke159]

Have you already found an answer? I want to do something similar. Both workbooks can be in the same folder. But people will be accessing one while I need to be able to view the data in the other. Both workbooks will be on a central server location.

[@katyro_00]

@@rke159 Hi! Nothing yet. I've tryed sharing it in Office 365 for teachers but macro does not work in excel online. I basicly want to have one workbook with form (for everybody to acceess, from any computer) and a second one with data which would be populated automaticly (for me alone - on cloud).

[@nazmidaud2665]

thank you

[@MohamedAhmed-on4qb]

That Premium tutorial series is a wonderful idea. I look forward to follow that series. Thank you

[@TeachExcel]

Great! ) I'll keep you updated!