Add Data to Specific Sheet from User Form - Advanced Excel VBA Userform

This Advanced UserForm Tutorial explains how to transfer data from UseForm to specific sheet. How to identify last filled row on any sheet and then transfer data from user form to next available row with simple vba code.

Watch all UserForm Examples at below link :

[sigmatabs]

It really helped sir, Thanks for your video.

[chadsummers]

Very useful info...Thank you for sharing!!!

[saupham]

This code works for table format Thanks

[lakhera]

Thanks for sharing the, can we avoid to adding duplicate data based on values in specific column?

[LizzieW]

I used this and it worked well within the same workbook. How do I get the userform to add data to another workbook?

[ronolds]

This is somewhat helpful. However, if you were to make the Excel file used in the demonstration video available, it would be much more useful.

[chanmonanrie]

When I click the Transfer Data button, this message box pops up "Compile error: Variable not defined". The Code is exactly the same as in your video. Any solution for this?

[munnanurvenkat]

Super sir. But update data and delate row data format plage video sir

[chanmonanrie]

Can Search command be added in this form to search from both pages?

[unuskpm]

Thank you so much sir, I have one query, I have formatted Table with Total Row enabled in each Worksheet. As per your code data is being transferred to the next available empty row after Total Row. How to add data before Total Row. Please help me.

[dairy]

I'm having issues with your code last row = ActiveSheet.Cells(Rows.Count, 1).End(x1Up).Row

[mdhashmath]

but sir is it possible to selected different columns ranges in the same sheet for different years
Ex 2019 jan to dec, 2020 jan to dec... So on

[mgpkumar]

Sir, Could you do a project on Tree view control on user form in excel!

[rcmizohranglung]

Thats really good and clear Thanks...
Can we transfer data to different column instead of different sheet ?

[heyaedhiii]

Hi. How do I use this form for the newly added sheets? I mean, how does the combobox automatically detect the new sheets added when we export new data into a workbook?

[saimusic]

Sir how to add search and update button in this userform

[naveedasghar]

Hi i must say productive lesson for excel students ! here i want to ask you after watching this video, suppose despite using first, second and third sheets how can we use one sheet where we make tables of first, second and third and transfer data with the help of combobox to specific cells ? i hope u get my question.
regards

[JNWPLAYSMLBB]

can u pls put the link to download this File ???

[muraliiyer]

nice learning I have huge data file want to split into two or three sheets, some of the fileds are common for all the two/three sheets, can u guide how to do vba coding.

[Muzaffareng]

Dear Sir, Great work... I want to know about my problem if you can help me,
1. I have say 5 sheets
2. Every sheet has different data
3. I have created 5 data entry form
4. I have a master sheet where i have command button to show the form, where I have a label and a text box in which i shall insert the date that is common for all 5 sheets.
5. After date I have combobox with five sheet names, when I select a name from, its respective form must be open and transfer data from that form to selected sheet.
I need your help or suggestion or modification if you can

Regards