Further to my recent email, this direct transfer method has been demonstrated and explained in a noticeably clear and comprehensible way. I'm happy to express my thanks and appreciation to you!
Which method are you using to copy data from one sheet to another with Excel VBA - 1,2,3,4 ... or 5? Let me know in the comments, I will get back to you ..👇
I would like to use Method 5 to move the last piece of data added to one sheet and automatically move to another sheet. In the VBA lessons you did we did a "List" tab. I would like to add the data to this worksheet. However, I am getting Error- Run-time1004 Application-defined or object -define error. I am getting this same error on Methods 3 thru Method 5. If there is a way to help, that would be much appreciated!
You are superb Brother! I have seen all of your videos and made my notes which helped me a lot with my daily tasks. Thanks! Lots of Love & Wishes from India!
Advanced Autofilter via vba is by far the fastest way to move data between sheets. I tested copy and paste vs AAF, and the time difference was literally less than half the time. Good, clear content as always 👍 I see you have succumbed to the lock down trim....I’ve had a wife trim very similar 🤣
Copying is slow ... but this video actually covers direct transfer, not copy, the reference to 'copy' is just to bring the punters in. Oh, and a picture of the lockdown cut is required!
Thank you very much Chris for your great lesson. I have been searching for days fortunately I've found you the Super great teacher for VBA Excel. Thanks millions. Subscribed, definately liked! Looking forward to more lessons
@@TigerSpreadsheetSolutions Yes, I did bookmark your website as well. There was a developed data entry macro excel form that hide all the sheets. I am trying to find the way how to collect all data from 60 fields into master sheet. I dont know if I can use your method 5.
@@TigerSpreadsheetSolutions thank you very much for your quick reply Chris. I tried method one to extract data from data entry excel form and received the run-time error'1004': application-defined or object-defined error. I created 2 sheets data, template as yours and copied your code of method 5. I also create the origin and destination cells but dont know why it does not work for me
Hi Rudolf, thanks - I don't recommend copying complete columns because it's resource-intensive. But, I'm sure you can use and internet search to find the required VBA ... good luck!
This Video is great. One question though how can you have the code work without always clicking the play button? So when you type the value in one cell it auto copies it to another.
Hi there - thank you! It's possible to get a macro to run when a value changes in a cell using what are called workbook event triggered macros. I don't recommend these however, because you very quickly feel like you've lost control with macros being triggered in the background constantly. That's why I recommend using buttons to trigger macros.
I am slightly confused by 6:55. Since you changed the Origin to the Data sheet, why isn't the origin pulling the address from H5 on the Data sheet? Is it because range.value function only pulls from the active sheet?
Hi there, thanks a lot for this video.. Very informative i must say.. I do a lot of copy pasting from one workbook to another Condition - the cell that i will be copying from one workbook to another should happen only when a value matches.. (match function) How can i do this? Need your valuable assistance
Hi Pradeep - you'd have to combine the techniques taught in this video with others such as conditional statements. I would recommend one of our longer VBA learning series to get to grips with the skills. Good luck!
Hey Chris, This is interesting but what if I want this to work on auto so when data is entered in the 1st sheet it will also appear in the destination sheet with using a play or activate button. The next step would be to sort the data on the destination sheet and only show the top ranking results with the code running on auto. Is there a more detailed video on your website?
@@TigerSpreadsheetSolutions Yes I was thinking of an auto sort as I add in new data and display the sorted results on another worksheet. I trying to learn how to do this. Thanks
Love the ideas behind this video. I understand the code, however when I run it from Method 3 onwards I get Run-Time error '1004': Application-defined or object-defined error. The template sheet is active, I added an extra line of code to activate the worksheet. I do not know why I am getting this error? Worksheets("Template").Activate
Range("E2").Value looks at the active sheet because no worksheet name is mentioned If you're on the Template sheet, it will look at the cell E2 on the Template sheet - I'm not sure that's what you want it to do?
@@TigerSpreadsheetSolutions That was the issue, both E2 and H1 were empty. Method 3 is working!! You mentioned Excel Basic Course, I need to brush up, its been about 15 years since I looked at VBA. I wish Microsoft improved its error messages, it chews up so much time trying to track errors down. Thanks so much for your reply, looking forward to going through your course.
Great video Chris, thank you very much. I have downloaded your file for the link provided and when I run the "Use_Table_To_Copy_Data() routine" and I get a "Run-time error ‘1004’: Application-defined or object-defined error". I haven't changed anything in your code. Are there any settings that I have to perhaps change on my side?
Hey Chris, So what if I have to create a new sheet on daily basis with date as the name of sheet and I have to copy the headers from the previous sheet. I know I have might have to use a variable for the sheet names but I am unable to find some example around it to get a reference. I have created a vba code to create new sheet and change its name to date but unable to proceed further. Can you help me here?
@@TigerSpreadsheetSolutions Okay sir, thank you; by the way, I'm constructing a fuel consumption form with VBA, and it requires a monthly summary report with five distinct sorts of structured forms. I'm grateful for your videos since they push me to accomplish my task, even if I'm still slow I can still notice progress.
Dear Sir we have three sheet 1. MR Form 2. SMR 3. Master Sheet
First we make MR Form For the Request so we need to automatically Data Transfer with SMR Sheet and Master sheet and save data after that when we received material we can edit SMR Sheet with other details which cells is blank so when we need to update SMR Sheet then automatically we need to save with Master Sheet so please I want your help
Thank you for this really helpful tutorial! As someone who is not fluent in VB scripting, this video was able to demonstrate clearly how each method works. I am also looking for one that automatically looks up a certain column based on an identifier (more like an automatic VLOOKUP), and found it here --> th-cam.com/video/UwH1jit7ars/w-d-xo.html. Thanks again!
🔥WATCH NEXT: The Future Of Excel VBA?
th-cam.com/video/Z62yORhPr3Q/w-d-xo.html
Further to my recent email, this direct transfer method has been demonstrated and explained in a noticeably clear and comprehensible way. I'm happy to express my thanks and appreciation to you!
You're welcome, Shlomo!
Which method are you using to copy data from one sheet to another with Excel VBA - 1,2,3,4 ... or 5? Let me know in the comments, I will get back to you ..👇
I'm still copy and pasting this should save me hours thanks Chris
I would like to use Method 5 to move the last piece of data added to one sheet and automatically move to another sheet. In the VBA lessons you did we did a "List" tab. I would like to add the data to this worksheet. However, I am getting Error- Run-time1004 Application-defined or object -define error. I am getting this same error on Methods 3 thru Method 5. If there is a way to help, that would be much appreciated!
Same here
Here as well.
Good information, thx. I’m learning VBA at 60-something and your presentation is easily digestible.
Welcome to the community - do take a look at our other videos on VBA
You are superb Brother! I have seen all of your videos and made my notes which helped me a lot with my daily tasks. Thanks!
Lots of Love & Wishes from India!
That's very kind of you my friend, keep enjoying the videos!
Advanced Autofilter via vba is by far the fastest way to move data between sheets. I tested copy and paste vs AAF, and the time difference was literally less than half the time. Good, clear content as always 👍 I see you have succumbed to the lock down trim....I’ve had a wife trim very similar 🤣
Copying is slow ... but this video actually covers direct transfer, not copy, the reference to 'copy' is just to bring the punters in. Oh, and a picture of the lockdown cut is required!
VBA makes this so easy! Really nice topic
Thanks Bart, I agree!
Excellent work, I started off thinking what is he doing? but your code ended up with a much cleaner solution than I expected.
Thanks Steven - love this comment, I like to hold you in suspense as long as possible :-)
Thank you very much Chris for your great lesson. I have been searching for days fortunately I've found you the Super great teacher for VBA Excel. Thanks millions. Subscribed, definately liked! Looking forward to more lessons
Fantastic to hear Tammy, welcome to the community! We have many VBA videos you'll like ...
@@TigerSpreadsheetSolutions Yes, I did bookmark your website as well. There was a developed data entry macro excel form that hide all the sheets. I am trying to find the way how to collect all data from 60 fields into master sheet. I dont know if I can use your method 5.
@@TigerSpreadsheetSolutions thank you very much for your quick reply Chris. I tried method one to extract data from data entry excel form and received the run-time error'1004': application-defined or object-defined error. I created 2 sheets data, template as yours and copied your code of method 5. I also create the origin and destination cells but dont know why it does not work for me
@@TigerSpreadsheetSolutions Hi Chris, I just tried Method 2 seems working but not dynamic.
Thank you so much, Sir. This is great learning video for me as never been using VBA. Thanks again Sir.
I really love all of your VBA videos, always super helpful, thank you!
Thank you my friend and welcome to the channel!
Thank you! I’m glad to be a subscriber!
Thanks a lot, I needed this moving a ton of data around this cut time down to nothing damn
Great to hear - that's the power of VBA!
Thank you for making this video
This is clearly explained ! 👍
Thank you! I enjoyed putting this one together ...
very helpfull video, thank you
It's a pleasure - see you in another video on the channel!
great video i however need to copy over complete columns do you have a video with an example script of that
Hi Rudolf, thanks - I don't recommend copying complete columns because it's resource-intensive. But, I'm sure you can use and internet search to find the required VBA ... good luck!
simply you are magic
Thank you my friend - I'm happy you enjoyed this one!
This Video is great. One question though how can you have the code work without always clicking the play button? So when you type the value in one cell it auto copies it to another.
Hi there - thank you! It's possible to get a macro to run when a value changes in a cell using what are called workbook event triggered macros.
I don't recommend these however, because you very quickly feel like you've lost control with macros being triggered in the background constantly. That's why I recommend using buttons to trigger macros.
I am slightly confused by 6:55. Since you changed the Origin to the Data sheet, why isn't the origin pulling the address from H5 on the Data sheet? Is it because range.value function only pulls from the active sheet?
It's a difficult one to explain. I would recommend dowloading the file and practising yourself. Good luck!
Hi there, thanks a lot for this video..
Very informative i must say..
I do a lot of copy pasting from one workbook to another
Condition - the cell that i will be copying from one workbook to another should happen only when a value matches.. (match function)
How can i do this? Need your valuable assistance
Hi Pradeep - you'd have to combine the techniques taught in this video with others such as conditional statements. I would recommend one of our longer VBA learning series to get to grips with the skills. Good luck!
How could you change this to copy a formula instead of just a value? Is it possible
Hey Chris, This is interesting but what if I want this to work on auto so when data is entered in the 1st sheet it will also appear in the destination sheet with using a play or activate button. The next step would be to sort the data on the destination sheet and only show the top ranking results with the code running on auto. Is there a more detailed video on your website?
What do you mean by 'in auto'? You want it to run without clicking a button?
@@TigerSpreadsheetSolutions Yes I was thinking of an auto sort as I add in new data and display the sorted results on another worksheet. I trying to learn how to do this. Thanks
Love the ideas behind this video. I understand the code, however when I run it from Method 3 onwards I get Run-Time error '1004': Application-defined or object-defined error. The template sheet is active, I added an extra line of code to activate the worksheet. I do not know why I am getting this error?
Worksheets("Template").Activate
Sheets("Template").Range(Range("E2").Value).Value = _
Sheets("Template").Range(Range("H1").Value).Value
Range("E2").Value looks at the active sheet because no worksheet name is mentioned
If you're on the Template sheet, it will look at the cell E2 on the Template sheet - I'm not sure that's what you want it to do?
@@TigerSpreadsheetSolutions That was the issue, both E2 and H1 were empty. Method 3 is working!! You mentioned Excel Basic Course, I need to brush up, its been about 15 years since I looked at VBA. I wish Microsoft improved its error messages, it chews up so much time trying to track errors down. Thanks so much for your reply, looking forward to going through your course.
Great video Chris, thank you very much. I have downloaded your file for the link provided and when I run the "Use_Table_To_Copy_Data() routine" and I get a "Run-time error ‘1004’: Application-defined or object-defined error". I haven't changed anything in your code. Are there any settings that I have to perhaps change on my side?
Hi Luigi - I think there's actually a mistake in the download file. Change G4 to G5 and H4 to H5 in that macro and things should work.
@@TigerSpreadsheetSolutions Thanks Chris, all working now.
Luigi Liccardo thanks for pointing it out
Hey Chris, So what if I have to create a new sheet on daily basis with date as the name of sheet and I have to copy the headers from the previous sheet. I know I have might have to use a variable for the sheet names but I am unable to find some example around it to get a reference. I have created a vba code to create new sheet and change its name to date but unable to proceed further. Can you help me here?
Hi Sir!
Can I ask? where can I put these codes?
Put them in the VBA editor - see our beginner VBA videos for more!
@@TigerSpreadsheetSolutions Okay sir, thank you; by the way, I'm constructing a fuel consumption form with VBA, and it requires a monthly summary report with five distinct sorts of structured forms. I'm grateful for your videos since they push me to accomplish my task, even if I'm still slow I can still notice progress.
Dear Sir
we have three sheet
1. MR Form
2. SMR
3. Master Sheet
First we make MR Form For the Request so we need to automatically Data Transfer with SMR Sheet and Master sheet and save data
after that when we received material we can edit SMR Sheet with other details which cells is blank
so when we need to update SMR Sheet then automatically we need to save with Master Sheet so please I want your help
i will be provide you excel sheet
You can learn the required skills on the channel - good luck!
Robinson Ruth Young William Hernandez Matthew
Thank you for this really helpful tutorial! As someone who is not fluent in VB scripting, this video was able to demonstrate clearly how each method works. I am also looking for one that automatically looks up a certain column based on an identifier (more like an automatic VLOOKUP), and found it here --> th-cam.com/video/UwH1jit7ars/w-d-xo.html. Thanks again!
Thank you - great to hear the video helped! See you in another one on the channel ...