Excellent..... 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
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?
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?
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.
@@ExcelDestination thank you sir, but this video is about protected or unprotected all sheets, my question is is there any code to protected or unprotected only the target sheet? ?
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.
Do you have a version of this form that allows you to use existing data (sheet 1) to specific sheets within the work book. For example, I have 100 students who are listed on sheet 1, and I want to move some of these students to sheet 2, some to sheet 3, some to sheet 4. Kind Regards, Craig
Hi Sir Good Morning, I always watching your videos and Learning Very Nice. Can you Tell me How to do Codeing if I want SEARCH and UPDATE In this Userform.plz... Thank you.
Sir I am beginner .This tutorials are only for transfer data to specific sheet.If am Adding SEARCH and UPDATE command then.What will be CODE Plz Tell me... Thank you.
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
Really sir very nice video...I would like to ask one question....if I want to check duplicate entry...suppose same phone number is exist in any sheet then how can we know about that sheet name and cell address before transferring the data plz guide me
Thanks for watching! there is another tutorial uploaded by me for preventing duplicate entries in excel using vba code. I hope that will help you. Link is : ua-cam.com/video/yPUCx9HTVvo/v-deo.html
Dear sir...it is not working...if I am using target sheet then it is not working...if I give use single sheet then it is working...sir if you don't mind then please give a code with taking the reference of this video.
@@ExcelDestination sir i have two option button. One is Dr. And second is Cr. And for only one textbook I have. Now I want to entry data as per next row... How to do it.
Dear sir your video is very good and useful...I need your help in one area...in this userform I want to add search button and update button...when I search the particular data of particular sheet...I could able to update the data also...please provide the codes for that and how can we do that...it's very urgent sir.I will be highly obliged.
@@ExcelDestination sir can you please make a video of what i said ? please.. because i tried many times and also searched in youtube and also Google but not find any videos of what i want... please make a video for me if its possible 🙂
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
Thank you for this informative video... But while I was running the code I was getting variable not defined error...i.e targetsheet and last row not defined.... When I defined it... the code ran successfully...just wanted to ask how come you didn't get the error as you have no where defined targetsheet and last row in your video... I am new to Excel Vba and userforms...so kindly clarify.....
Hello There, The code is working fine. However there is one issue. On the workbook which I've made there are two worksheets. The first one is named "HOME" and the 2nd is "RawData". To run the userform, one will have to click on a command button which is on "Home" worksheet. Whatever data is entered in the userform form, should copy in "RawData" worksheet. However, it's not happening. The userform is copying the data under "Home" worksheet. There is one more thing I've noticed. When I'm on "RawData" worksheet and runs the userform, by using developer tab, it copies the data correctly From the userform under the specified row and column in "RawData" worksheet. However it's not copying the data to "RawData" worksheet when I run the userform from "Home" worksheet. Instead its copying it on "Home" worksheet. Please guide me with the correct VBA coding, as I've tried changing the worksheet name as well on the VBA codes shown inthe video, but it didn't make any difference. Thanks.
you need to use Worksheets("TargetSheet") instead of Worksheet(TargetSheet)..........there may be more error......however by looking at the line, I can say only this.
This is very simple. I am not sure, why it is not working for you. For Protected sheet, you need to unprotect your sheet through vba then it probably works.
Nice explanation, Everthing is correct mentioned in userform but still not activate the target sheet & transfer the data. Pls help.. May I share the file give me your mail id.
Hi, did you get an answer? I have the following problem and hope you might be able to assist. I have followed the coding however, when I run the code, I get an "Application-defined or Object-defined error". I need help with this and would appreciate if someone can assist me
@@georgethanos1661 kindly can you explain.... in my case debug this line "lastrow = ActiveSheet.Cells(Rows.Count, 1).End(x1up).Row" I don't know what is wrong here....
@@mafrazilyas Hi, I am not in front of a pc..declare the variables "dim lastrow as long"..the code is End(xlup). I cannot distinguished if you write it correct
It really helped sir, Thanks for your video.
Welcome
Very useful info...Thank you for sharing!!!
Nice explanation, thanks
welcome
This code works for table format Thanks
Excellent vidéo , Thanks... Thanks.
very useful..thank you
Awesome guide!
Thanks for sharing the, can we avoid to adding duplicate data based on values in specific column?
Thanks, Sir.
But please help me with the excel work so that we can get access to the code.
I used this and it worked well within the same workbook. How do I get the userform to add data to another workbook?
Excellent..... 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
Yes, definitely
Can Search command be added in this form to search from both pages?
thank you so much for this
Very Good...
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?
i have the same, he needs to define his variables.
Sir, Could you do a project on Tree view control on user form in excel!
Excellent
Thanks
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.
Super sir. But update data and delate row data format plage video sir
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?
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.
Sir how to add search and update button in this userform
dir sir, when the target sheets are protected sheets do you know the vba code? Thanks Chris from Holland
you can take help from below given tutorial :
ua-cam.com/video/AE3R5WGgdJc/v-deo.html
@@ExcelDestination thank you sir, but this video is about protected or unprotected all sheets, my question is is there any code to protected or unprotected only the target sheet? ?
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.
If you have this Project and want expert support, you can write email to exceldestination@gmail.com
can u pls put the link to download this File ???
Do you have a version of this form that allows you to use existing data (sheet 1) to specific sheets within the work book. For example, I have 100 students who are listed on sheet 1, and I want to move some of these students to sheet 2, some to sheet 3, some to sheet 4. Kind Regards, Craig
Thats really good and clear guide..... Thanks...
Can we transfer data to different column instead of different sheet ?
hi Hranglung have u got solution for what u asked ?
I'm having issues with your code last row = ActiveSheet.Cells(Rows.Count, 1).End(x1Up).Row
try "A" for column number (instead of 1), and it's xlUp (the letter "l" and not number "1").
How about if we want to start the value from row 5 or any others rows?
you can use that in looping statement
can you teach me how to searh update with this project ? thank you
Thanks bro
Hi Sir
Good Morning,
I always watching your videos and Learning Very Nice.
Can you Tell me How to do Codeing if I want SEARCH and UPDATE In this Userform.plz...
Thank you.
Hi sir
Can you Suggest me what Codeing work if i want to Search and Update Data in any specific Worksheet.plz
you can take help from following tutorial :
ua-cam.com/video/1kpRa0Z6-9g/v-deo.html
Sir
I am beginner .This tutorials are only for transfer data to specific sheet.If am Adding SEARCH and UPDATE command then.What will be CODE Plz Tell me...
Thank you.
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
I guess it is kinda off topic but do anyone know a good site to stream new series online ?
@Aarav Alan flixportal :P
@Yael Wallace thank you, signed up and it seems like they got a lot of movies there :D I appreciate it !!
@Aarav Alan No problem =)
Really sir very nice video...I would like to ask one question....if I want to check duplicate entry...suppose same phone number is exist in any sheet then how can we know about that sheet name and cell address before transferring the data plz guide me
Thanks for watching! there is another tutorial uploaded by me for preventing duplicate entries in excel using vba code. I hope that will help you. Link is :
ua-cam.com/video/yPUCx9HTVvo/v-deo.html
Dear sir...it is not working...if I am using target sheet then it is not working...if I give use single sheet then it is working...sir if you don't mind then please give a code with taking the reference of this video.
Perfect.
thanks
@@ExcelDestination sir i have two option button. One is Dr. And second is Cr. And for only one textbook I have. Now I want to entry data as per next row... How to do it.
NICE ,LIKE TO LEARN THHIS ,BUT I DNT KNOW WHERE TO BIGEN
Dear sir your video is very good and useful...I need your help in one area...in this userform I want to add search button and update button...when I search the particular data of particular sheet...I could able to update the data also...please provide the codes for that and how can we do that...it's very urgent sir.I will be highly obliged.
Dear Sir, I will require help in that.. Please help us..
Hello !
Please, how could you format TextBox3 so that the numbers transfered to spreadsheet would not be a string but an Integer ?
Thank you so much sir ❤️
And one more question
Is it possible to transfer same data to 2 specific sheets together ? If yes then please tell us how ?
you need to add code for two sheets. process is same.
Codes also same ?
@@ExcelDestination sir I did it same codes and same process but results is just data transfar only one sheet can't transfer to both sheets
@@ExcelDestination because maybe userform is reset automatically when combobox1 selection sheet transferred right sir ?
@@ExcelDestination sir can you please make a video of what i said ? please..
because i tried many times and also searched in youtube and also Google but not find any videos of what i want...
please make a video for me if its possible 🙂
its not working for me, data is not being transferred to selected worksheet.
Can we transfer data to different column instead of different sheet ?
yes
@@ExcelDestination then kindly guide us what will be the coding for that !! if possible make a video.
thanks & Regards
Sir, How Can i add listbox in this userform?
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
for any vba project, you can write to exceldestination@gmail.com
What if you want to modify data on the worksheets?
you can watch another tutorial for that at following link :
ua-cam.com/video/uWLpEDjS_00/v-deo.html
Need Help
it shows error 13 and make the line highlight "ActiveSheet.Cells(lastrow + 1, 1).Value = Serial_Number.Value"
Sorry sir vimal ji nahi rahe
Thanxx
Sir how we create excel page through user form in excel like a inventory software???
Are you able to send the VBA code to my email or paste a link where I can access it?
let me check , if I have this file.
Thanks Sir... i need this in excel formate. need code.
let me check, if I have the original file. Pls. send me email at exceldestination@gmail.com
hello sir how to search from sheet1 and sheet2
You can check another UserForm tutorial for Search, Display and add data. Link is given below :
ua-cam.com/video/B40-vfnVagc/v-deo.html
It's a very useful sir, but i have a question❓
Can we write something according to searching any text that is written in any row or Column
Yes, you can
how to solve compiler error targetsheet because Variable not define pls help me
You can try by defining variable also. Cell Reference is easy in case you don't have programming background.
I try to do this but can, t. Debug for object. How is that?
without looking at your code. can't say anything. You can send me email at exceldestination@gmail.com
Thank you for this informative video... But while I was running the code I was getting variable not defined error...i.e targetsheet and last row not defined.... When I defined it... the code ran successfully...just wanted to ask how come you didn't get the error as you have no where defined targetsheet and last row in your video...
I am new to Excel Vba and userforms...so kindly clarify.....
I can not tell you where is the issue, you can send me your file at exceldestination@gmail.com
It keeps entering data into the same cell, it doesn't move down a cell after data is entered. Any ideas?
Sir please help i want to chage every time cell range when vba run plzz make user form which ask cell rang when vba run after vba run
that would require different code. If you need this code for your project. Please send me email at exceldestination@gmail.com Thanks!
Hello brother please how can i insert my user form from VBA to my sheet ?
Press Alt + F11
Go to Insert
Click userform
SUBSCRIPT OUT ERROR WHAT CAN I DO
Hello There,
The code is working fine.
However there is one issue.
On the workbook which I've made there are two worksheets. The first one is named "HOME" and the 2nd is "RawData". To run the userform, one will have to click on a command button which is on "Home" worksheet.
Whatever data is entered in the userform form, should copy in "RawData" worksheet.
However, it's not happening. The userform is copying the data under "Home" worksheet.
There is one more thing I've noticed. When I'm on "RawData" worksheet and runs the userform, by using developer tab, it copies the data correctly From the userform under the specified row and column in "RawData" worksheet.
However it's not copying the data to "RawData" worksheet when I run the userform from "Home" worksheet. Instead its copying it on "Home" worksheet.
Please guide me with the correct VBA coding, as I've tried changing the worksheet name as well on the VBA codes shown inthe video, but it didn't make any difference.
Thanks.
i face error in this code i have type
WorkSheet(TargetSheet).Active
but it show me the Error
how to fix it
Worksheet(Targetsheet).activate
@@FaizurRahman00 its not a gramer error its a logical error
Share your complete code,
@@FaizurRahman00 plz give me whatsapp no i will send u snapshot of the error
you need to use Worksheets("TargetSheet") instead of Worksheet(TargetSheet)..........there may be more error......however by looking at the line, I can say only this.
Sir Pls make a update,delete,view commond button
Not working when protected.
This is very simple. I am not sure, why it is not working for you. For Protected sheet, you need to unprotect your sheet through vba then it probably works.
Nice explanation, Everthing is correct mentioned in userform but still not activate the target sheet & transfer the data. Pls help.. May I share the file give me your mail id.
Hi, did you get an answer? I have the following problem and hope you might be able to assist. I have followed the coding however, when I run the code, I get an "Application-defined or Object-defined error". I need help with this and would appreciate if someone can assist me
@@stefanventer6356 Declare the variables after the line: Private Sub CommandButton1_Click() . dim TargetSheet as string, lastrow as long
@@georgethanos1661 kindly can you explain.... in my case debug this line "lastrow = ActiveSheet.Cells(Rows.Count, 1).End(x1up).Row" I don't know what is wrong here....
@@mafrazilyas Hi, I am not in front of a pc..declare the variables "dim lastrow as long"..the code is End(xlup). I cannot distinguished if you write it correct
@@georgethanos1661 that was L instead of 1! Thank you so much for the help!
Sir Pls make a update,delete,view commond button