UserForm with Multiple Database Sheet (Transfer Data to Worksheet on Condition)

[@pakistankayrangaakaysung]

Thank. I am beginner but by this video I learnt so many things with techniques.

[@greenapple7005]

I am a property handling guy and managing my inventory has always been an issue for me. With this video I can log my properties in respective sheets. I wish if there were some filters features also added to search the desired property by means of its Price range, by Size, by Type and by date. Overall a great great help. I truly appreciate and admire the dedicated work done in this video. Grateful // IQBAL

[@yogeshpadte1481]

thank for the call log form. Looking forward for a similar Log form for maintaining incoming outgoing cash flow in coming days. thanks

[@annefgm]

Thank you so much sir😍 you really help me solve my vba problem

[@akio6505]

Thanks! How do you share just the form and super hide the sheets as entries will be confidential?

[@bryce867]

Informative speech

[@storekeeperTips]

Really very useful and well explanation dear friend

[@thedatalabs]

Thanks for your feedback!

[@ckumarmehta8370]

Thanks!! Nice video to learn something new..

[@poosalaanil5754]

Its Very Helpful

[@lindleybulado9203]

Hi there. Thank you for the free tutorial. How it is done if you want the data entry to one sheet only but different cell columns

[@naresh6943]

Very useful video, hats off to u! Also, could u make similar video for Google Sheets as well?

[@thedatalabs]

Thanks for your feedback! Please watch this Google Sheets Tutorial. kzbin.info/www/bejne/gJvWhWZqo8ibfZY

[@pkmnamboothiri]

Very good explanation. Hats off. Big Salute sir.. Could we add two more keys instead of 2. Means 'Delete' and 'Modify' in the same data entry? Then what will be codes? I have already seen your other videos for that. But if my search criteria are two how can I add it?

[@user-Fatima.BHA.Shaikh]

If we have used check boxes for yes or no in our excel form can we still get all the data in excel as you have shown in this video?

[@jvnvzo]

Hi. Cool video. Is there a way where you can add SEARCH bar to search and display entry then add notes? And when the new NOTES are added, it will show a thread of notes. Just like Call Center CRM where you can add notes on an account or entry.

[@naniroses129]

So thanking you brother

[@whatsnext6598]

Great video... Sir can you make a video on were we use listbox in VBA with multiple select and how does it appear on database sheet, or does it appear in one cell ?

[@tapan4253]

thanks but i have one doubt, call summary auto fit because if we will put any thing like 4 or 5 lines then it will take proper space there in another sheets and second thing is I need to creat a button and in that button open this open when I will on it. if it possible then how? plz let me know

[@nikklim2504]

Thanks for this video, i was able to make my project lately..straightforward and awesome ,but i have questions 1. how can i direct the cursor directly on the first data entry field in form and then to go to next entry field using enter or tab?i should also my cursor when needed? 2. in my list (which is the sheet), i wanted to show a blank row in between entry not every row, code please and where to place them in code? Thank you in advance.

[@sadupadhananjaya3504]

@TheDataLabs sir I need the coding for modify and delete buttons for a data entry form with multiple data sheets, I have watched this video too. But this is regarding single data sheet. how can I do it with multiple data sheets. I can't understand. please help me sir.

[@kapaunkelo6939]

Hi...Can you make one video of Multiple Database Sheet with Search, Edit, and Delete buttons ?

[@onedaytradingcrypto2758]

nice tutorial

[@johnmichaelparecto5167]

Hi Sir your code works perfectly. But I have one concern what code needed to give an error message that field required entry? Where to add it in the code you created in the video?

[@thedatalabs]

Please watch this tutorial. It will cover the validation part. You can apply the same logic and code. Thanks! kzbin.info/www/bejne/ZpOpgH6mlrh8eMk

[@johnmichaelparecto5167]

@@thedatalabs sir I checked the link but it is not helpful How I wish you can create a video or share a code for validation in this entry you made in this video.

[@sreejithkrishnan1111]

Thank sir very useful...

[@lindseyleicester5203]

This video is amazing and has helped me so much. Please could you tell me how I can allow data entry onto a protected sheet using the user form?

[@PaulEllisBIGDATA]

LOVED THE VIDEO!

[@mansoorali19]

Very nice

[@lourdvicalcindor2910]

Hi ! Thanks for this video ! Is it possible to submit the data into already existed worksheet or we need to recreate them from scratch ? Thanks

[@bestof9764]

AMAZING APPLICATION EXCEL VBA

[@ravishankar9289]

Can you make video on how to share userform data to other onedrive accounts

[@mohammadzaid460]

Sir indeed this was great video and much helpful. Is it possible to save the same data in multiple sheets? If yes please let know how to do that

[@saniak5262]

please share if you find the solution. I am looking for that too. Thank you

[@TheDramaticirony]

Hi. How do you add new data in without overwriting the existing data in the list ? I tried your method and the data will start from the first row, overwriting my existing data

[@timcrouse8475]

Is there a technique to have each of the data sets stored on the same sheet but in separate sections each with its own header row?

[@namreshchor]

Hi I have seen many of your data entry and all are very useful .can you help me with different type of data base entry .for example in store . we need some parts/items . item number its location and description .with add item and search item and delete item

[@naveedasghar3022]

Hi nice video! i have a question instead of using different sheets for countries if we use one sheet where we put country names horizontally by selecting country from form data will transfer to specific cells.Hope you understand what i am asking?kindly make a video about it thanks & regards

[@Ashokthebull]

I followed the command. It is working and thank you for that. But there is a small error,, I have added just two options in the drop-down. Codes works perfectly fine, when I choose the 1st option to save. When I choose the second option datas are saved from bottom of the table not from top. Could you please guide me on where I went wrong? Thanks in advance!

[@reubenaguti2165]

Can 2 data entry forms submit data onto the same Excel sheet tab having the database, if one form has 18 text boxes and it is submitting from A2 to R2 with the buttons Save, Reset, Print, Edit, Exit, and Delete and the second form has 20 text boxes and it is submitting from S2 to AL2 with "submit" and "return" buttons on the second form to go back to the first form again

[@JenJen-fe6us]

Hi what if i need to transfer data to specific cell in that sheet. Not just the next available blank row. Example customer name should be transfered to cell B17 in that sheet

[@RohiniGgude]

Can you make a video adding data on top below header in above userform though I have watch that video in which u show how to add row but I want to apply code in above userform can you pls help with apply code in above userform 🙏

[@mci8313]

U got that solutions plz share with me I also looking for that

[@lukaspalintong]

Amazing. I've been looking for this tutorial for long time. Will this work on Google Sheets?

[@thedatalabs]

Thanks for your feedback! This is for MS Excel only as Google Sheets doesn't support VBA. Please watch the below tutorial for Google Sheets. Thanks! kzbin.info/www/bejne/h16soGOPap6hj6M

[@lukaspalintong]

@@thedatalabs Thank you for answering me. I need to transfer data to multiple sheets based on a condition as described in this video. I have already search your entire videos for Google Sheets but don't find any relevant tutorial yet.

[@thedatalabs]

I will try uploading a tutorial on that. Thanks!

[@oediarti2012]

Thanks sir

[@johnmichaelparecto5167]

Hello can you add sample coding in this entry to validate data? I am having trouble following the other tutorial .

[@karnank6934]

God bless u

[@cupidtablets5042]

Good Morning to you today Yr indeed an excel expert. we appreciate all you do for us. my contact manager is challenging me. when i save a contact, it overwrites the one i saved first. i therefore keep finding the last saved record and i cant access the earlier saved records

[@thedatalabs]

Thanks for your feedback! Please check the variable used to store row number.

[@scottmcintosh9396]

How to code to insert new row below headings and add a new entry there?

[@bhawyakumar1054]

Hi, i want to export data from excel sheet to userform combobox and date picker however, .value and.list doesn't work what object should be used

[@davidsumner397]

Hello Sir, I keep getting a Subscript out of Range Error on set shCountry =ThisWorkbook.Sheets(sCountryName). i can send the code to you if you have the time to look it over. the sheet name is the same as in the code so it must be somthing i am over looking in the code

[@CCAFO]

Hello, do you have the form for Journal entry?

[@Elucas89]

How in the code can I also send the form inputs to a master database sheet. So that the form inputs go to the country and also to a master database.

[@abdusalih3811]

thank you

[@airexpressgsacrescentstari9443]

Great job One question is if we would like to submit data in 2 sheets with on submit click is it possible??????

[@thedatalabs]

Thanks for your feedback! Yes, that's possible.

[@poosalaanil5754]

Could you pls provide App Script code for google sheets..It will helpful to us

[@sadupadhananjaya3504]

@TheDataLabs I really want this sir. Coding doesn't identify the selection of datasheets for modify and delete buttons when giving the serial number and it gives no record found though there is data in particular row. please help me to solve this problem sir. Shall I sent my project to your email if you can look at it sir.

[@daljeetsingh1231]

I am using Userform1 multiple times in different Excel worksheets. But, If I select Checkbox in the first Userform then another Userforms checkbox automatically selected. How can I separate them? I'm a beginner in coding so do not have much idea how can I segregate them to perform individually.

[@heng9876]

THIS IS AMAZINGGG! thank you so much!

[@mukhlisbuneri]

very nice video Sir.... how it will select newly inserted sheet(means other country) automatically in form dropdown list.??

[@thedatalabs]

Thanks for your feedback! You need to create dynamic drop-down. Please watch this video to learn how to create dynamic drop-down. Thanks! kzbin.info/www/bejne/nGi6ZHuIgbaMd9U

[@bmmmjm7823]

Hello Sir, would you mind taking a look at my coding to see why I keep getting an error code?

[@sandip01_11]

Sir Delete, Update button alao need in this form??

[@tronway5500]

Can you help us adding a search function please.

[@navaneethakrishnan4829]

Awesome 👍 I'm impressed sir... Please tell me how to add search options in this entry sir... Please help us sir... If possible tell me how to avoid duplication..

[@thedatalabs]

Thanks for your feedback! Please watch this tutorial. kzbin.info/www/bejne/f169lmmYjZyiq9U

[@easygetprojects8285]

I've watched the tutorial but still unable to search data from other worksheets using this form. Please help

[@tronway5500]

How do you apply that code to this form

[@krob123085]

Would you mind taking a look at my coding to see why I keep getting an out of range error code?

[@thedatalabs]

Please send it. I will go through that and let you know the reason of error and fix it. Thanks!

[@Muhammad_Sakil]

@@thedatalabs give me your email or whatsapp no....

[@mohammadtarique-sf8qm]

Please tell me entry code for transfering data to sheets of more than 25 parties

[@koungsareth8623]

Very much thanks if do like this in google sheet

[@thedatalabs]

Please watch the same tutorial for Google Sheets. Thanks! kzbin.info/www/bejne/gJvWhWZqo8ibfZY

[@theactionlab2186]

Can i get the source file(excel) of this userform

[@lourdvicalcindor2910]

Is it possible to transfer data in multiple sheet in the same submit ?

[@thedatalabs]

Yes, that's possible.

[@abeermuhammed2544]

Hi there May your help please It works for the 1st time, and now asking me to correct the error on the code Set shCountry = Thisworkbook.Sheets (sCountryName) I have tried to put quotations marks for (“sCountryName”) And still not working The message is ( run time 9 : subscript out of range) Your help please

[@thedatalabs]

It seems the country name selected in drop-down has no respective sheet in this workbook. Please check. Thanks!

[@Tieu72]

After I build this when I close the file it doesn't save. How do I do that? Thanks.

[@craigyamasaki8315]

is there a way to populate the data from the form to separate workbooks?

[@thedatalabs]

Yes, you can use lookup in VBA code .

[@faizsumbal]

Dear Sir, I am facing the same problem. Let me mentioned I have used your coding and excel sheets design too, but still experiencing Run-time error '9' "Subscript out of range ..... Set shCountry = ThisWorkbook.Sheets(sCountryName).....please advise what to. I have checked sheet name used in coding many a time that is perfact.

[@thedatalabs]

Please check the sheet name and use in bracket with double quotes. Hope it will work. Thanks!

[@faizsumbal]

Dear Sir, I have send an email and attached the Excel file with developer codes. My request is to please and check it and advise me how to remove the error. Thanks.

[@jamesmwanza4289]

Greetings, how do we do the same on Google sheets

[@diya2909]

Very awesome video sir...please guide us if we want to stop to enter duplicate customer I'd...for example if same customer I'd exist for India...in this case what can we do

[@thedatalabs]

Thanks for your appreciation! You can apply an additional validation to check customer id is already available or not. To validate, you can use match function in VBA. Please watch this video. kzbin.info/www/bejne/f169lmmYjZyiq9U Thanks

[@deeiskhan3781]

hello, I would like to ask why I can't add more data, and it replaces the row that i had just add? can you help me to fix this?

[@thedatalabs]

Please check the row variable. It should not be static. Thanks!

[@kale9915]

Hi how about if i want to separate between currency? for example if multiple tabs is USD,EUR,AUD..so each tab will have each currency, in video u show separate at multiple tabs based on countries..can u help me on this

[@thedatalabs]

You can apply the same logic. Thanks!

[@Ed-xb3sr]

Hi! Hoping you would see this. I'm having problem with the program, in the "Sub Submit_Form()" it says 'Compile Error: Variable not defined' i don't know what to do here now.

[@thedatalabs]

Could you please share the line of code where this error coming? Thanks!

[@dharmeshpatel1138]

I want to make something in excel using vba forms....for my c-store daily sales activity..if you can help me...i really appreciate

[@thedatalabs]

Please share your requirements on our email id. You can find our contact details in description box. Thanks!

[@Rheyaleng]

Hi sir can you add another button for update? I was able to add another button for modify but it's not saving the updated data 😢

[@averagerebuilders5188]

Hello Sir, I keep getting a Subscript out of Range Error on set shCountry =ThisWorkbook.Sheets(sCountryName)

[@thedatalabs]

Please check the worksheet name used in code.

[@omnathlamsal6036]

Sir how to search in multiple sheet plz give video link

[@sadupadhananjaya3504]

sir, how to edit the userform and save data to the same record in a particular data sheet when there are multiple datasheets .please help me sir

[@mohammadzaid460]

U got the solution? Even I want to know!

[@sadupadhananjaya3504]

@@mohammadzaid460 No I didn't get the solution. Did you get it?

[@kriti4698]

can we do the same in google sheets ?

[@thedatalabs]

Yes, please check our Google sheets tutorial. Thanks!

[@AtanuDigital.]

Please create a Small banking system Like Castomar profile Savings account Loan

[@colw8625]

I am have a problem with code, I have gone over it many times but keeps coming back with “can,t execute code in break mode “ and high lights the row.? Can I email the vba print out. Thank you

[@thedatalabs]

You have added break points in code. Please clear all the break in VBA window. From the Debug menu in VBA, choose Clear All Breakpoints (CTRL+SHIFT+F9). Thanks!

[@colw8625]

@@thedatalabsThank you for your very fast reply to my email, sorry no luck. Enter data into the form press submit button, comes up with do you want to reset this form, select Yes, form is cleared, but no data transferred to in any sheet. Pressing the reset button brings up a screen, runtime error, application defined or object to find error. Then shows the Icurrentrow..... in yellow. Any suggestions, Thanks Colin Worthy

[@thalamalfamilyartworktv3242]

hello sir do you have what apps or email i want to ask you something sir... t.q

[@sadupadhananjaya3504]

Sir can you tell me the code for modify and delete buttons for this kind of data entry form. I'm stuck in that case. please help me to solve this problem. please

[@thedatalabs]

Please watch this tutorial. Thanks! kzbin.info/www/bejne/f169lmmYjZyiq9U

[@sadupadhananjaya3504]

@@thedatalabs sir I need the coding for modify and delete buttons for a data entry form with multiple data sheets, I have watched this video too. But this is regarding single data sheet. how can I do it with multiple data sheets. I can't understand. please help me sir.

[@sadupadhananjaya3504]

@@thedatalabs I really want this sir. Coding doesn't identify the selection of datasheets for modify and delete buttons when giving the serial number and it gives no record found though there is data in particular row. please help me to solve this problem sir. Shall I sent my project to your email if you can look at it sir.

[@ajaybote3377]

Hi bro I need your help in your userform I want always enter data on top below the header, can help me with coding? It's urgent 🙏

[@thedatalabs]

Hope, you will find this tutorial helpful. kzbin.info/www/bejne/h4muaIB3atiUapY

[@ajaybote3377]

@@thedatalabs Thanks for this but can you plz help me with applying same code in this above userform.

[@ajaybote3377]

Will you help bro🙏

[@mci8313]

Bro u got ur solutions to add data on top row plz share

[@michcampos9336]

Can you send me a copy of that file? Thank you

[@msalam353]

Showing "Subscript out of Range" Error Please help on that issue

[@sruthisuresh391]

Hi! Hoping you would see this. I'm having a problem with the program, in the "Sub Submit_Form()" it says 'Compile Error: Variable not defined' i don't know what to do here now. Sub SUBMIT_DETAILS() Dim SHINDENTOR As Worksheet Dim SHFORM As Worksheet Dim ICURRENTROW As Integer Dim SINDENTORNAME As String Set SHFORM = ThisWorkbook.Sheets("FORM") SINDENTORNAME = SHFORM.Range("E12").Value Set SHINDENTOR = ThisWorkbook.Sheets(SINDENTORNAME) (here is the problem) ICURRENTROW = SHINDENTOR.Range("A" & Application.Rows.Count).End(xlUp).Row + 1 With SHINDENTOR .Cells(ICURRENTROW, 1) = ICURRENTROW - 1 .Cells(ICURRENTROW, 2) = SHFORM.Range("E6") .Cells(ICURRENTROW, 3) = SHFORM.Range("E9") .Cells(ICURRENTROW, 4) = SHFORM.Range("E12") .Cells(ICURRENTROW, 5) = SHFORM.Range("E15") .Cells(ICURRENTROW, 6) = SHFORM.Range("E18") .Cells(ICURRENTROW, 7) = SHFORM.Range("E21") .Cells(ICURRENTROW, 8) = SHFORM.Range("E24") .Cells(ICURRENTROW, 9) = SHFORM.Range("E27") .Cells(ICURRENTROW, 10) = SHFORM.Range("E30") .Cells(ICURRENTROW, 11) = SHFORM.Range("E33") .Cells(ICURRENTROW, 12) = SHFORM.Range("E36") .Cells(ICURRENTROW, 13) = SHFORM.Range("E39") .Cells(ICURRENTROW, 14) = SHFORM.Range("E42") .Cells(ICURRENTROW, 15) = SHFORM.Range("E45") .Cells(ICURRENTROW, 16) = SHFORM.Range("E48") .Cells(ICURRENTROW, 17) = SHFORM.Range("E51") .Cells(ICURRENTROW, 18) = SHFORM.Range("E54") .Cells(ICURRENTROW, 19) = SHFORM.Range("E57") .Cells(ICURRENTROW, 20) = SHFORM.Range("E60") .Cells(ICURRENTROW, 21) = SHFORM.Range("E63") .Cells(ICURRENTROW, 22) = SHFORM.Range("E66") .Cells(ICURRENTROW, 7) = Application.UserName .Cells(ICURRENTROW, 8) = Format([now()], "DD-MM-YYYY") End With SHFORM.Range("E6,E9,E12,E15,E18,E21,E24,E27,E30,E33,E36,E39,E42,E45,E48,E51,E54,E57,E60,E63,E66").Value = "" MsgBox " Data Submitted Successfully" End Sub

[@thedatalabs]

Could you please let us know which line of code is getting highlighted after error message? Thanks!

[@blaowpow61]

@@thedatalabs I have a similar issue. Can you assist via email?

[@KaviRaEnterprise-k1u]

I need this in Google sheet.

[@mhhridoy6246]

I need your help

[@odraude8773]

nice tutorial really, except the audio

[@AjazAlam09]

How to do this in userform vba

[@krob123085]

How to add a search button to this?

[@thedatalabs]

Please watch this tutorial. We have discussed all features. Thanks! kzbin.info/www/bejne/f169lmmYjZyiq9U

[@sameerarajapaksha-sy8rz]

When i go to save the document, there is a massage " Be careful ! Part of your documents may incuded personal information that can't be remove by the document inspector " please assist me.....

[@RameshS-v9f]

Goto security and disable

[@kaushalsinghrana7896]

Sir agar ye wala formula google sheet main lagana hai to.kaise karenge

[@thedatalabs]

Will upload a tutorial for Google Sheets. Thanks!

[@mhhridoy6246]

I need your help, please contruct.

[@Rahul_Seth]

Why We save file name into micro enable ...

[@thedatalabs]

Macro enabled file retains the macro code.

[@juan4all88]

sIR I KEEP GETTING ERROR AND WHEN I TRY TO DEBUG IT GETS ME HERE Sub submit_details() Dim shemployee As Worksheet Dim shform As Worksheet Dim icurrentrow As Integer Dim semployeename As String Set shform = ThisWorkbook.Sheets("form") ERROR SAYS runtime error '9' subscript out of range

[@thedatalabs]

Please check the sheet name. Thanks!

[@juan4all88]

@@thedatalabs can you assist me on this sir? this is the codes i was able to come up. as ypu can see my te,mplate have 19 rows. i dont know whats wrong. but im stuck on Set shform = ThisWorkbook.Sheets("form") error says subcript out of range Sub reset_form() Dim imessage As VbMsgBoxResult imessage = MsgBox("do you want to reset this form?", vbYesNo + vbQuestion, "reset confirmation") If imessage = vbNo Then Exit Sub ThisWorkbook.Sheets("form").Range("i10,i12,i14,i16,i18,i20,i22,i24,i26,i28,i30,i32,i34,i36,i38,i40,i42,i44,i46").Value = "" End Sub Sub submit_details() Dim shemployee As Worksheet Dim shform As Worksheet Dim icurrentrow As Integer Dim semployeename As String Set shform = ThisWorkbook.Sheets("form") semployeename = shform.Range("i12").Value Set shemployee = ThisWorkbook.Sheets(semployeename) icurrentrow = shemployee.Range("a" & Application.Rows.Count).End(xlUp).Row + 1 With shemployee .Cells(icurrentrow, 1) = icurrentrow - 1 .Cells(icurrentrow, 2) = shform.Range("i10") .Cells(icurrentrow, 3) = shform.Range("i12") .Cells(icurrentrow, 4) = shform.Range("i14") .Cells(icurrentrow, 5) = shform.Range("i16") .Cells(icurrentrow, 6) = shform.Range("i18") .Cells(icurrentrow, 7) = shform.Range("i20") .Cells(icurrentrow, 8) = shform.Range("i22") .Cells(icurrentrow, 9) = shform.Range("i24") .Cells(icurrentrow, 10) = shform.Range("i26") .Cells(icurrentrow, 11) = shform.Range("i28") .Cells(icurrentrow, 12) = shform.Range("i30") .Cells(icurrentrow, 13) = shform.Range("i32") .Cells(icurrentrow, 14) = shform.Range("i34") .Cells(icurrentrow, 15) = shform.Range("i36") .Cells(icurrentrow, 16) = shform.Range("i38") .Cells(icurrentrow, 17) = shform.Range("i40") .Cells(icurrentrow, 18) = shform.Range("i42") .Cells(icurrentrow, 19) = shform.Range("i44") .Cells(icurrentrow, 20) = shform.Range("i46") End With shform.AutoFilter("i10", "i12", "i14", "i16", "i18", "i20", "i22", "i24", "i26", "i28", "i30", "i32", "i34", "i36", "i38", "i40", "i42", "i44", "i46").Value = "" MsgBox "data submitted successfully!" End Sub

[@leonardkervincomeda6682]

hi sir can you help me on this? it has an error

[@thedatalabs]

Please share the error message and line of code where error is showing. Thanks!

[@PremKumar-wz3hr]

Hi sir error show in excel sheet ru-time error '429' Pls help me

[@thedatalabs]

Please share the line of code where you are getting this error. Thanks!

[@PremKumar-wz3hr]

@@thedatalabs thanks for reply problem has been resolved

[@greenledenterprises7613]

1. How can I "Delete" row from multiple Database sheets? 2. How to "Modify" row from multiple database sheets?