How to Copy Data from Another Workbook in Excel Using VBA
HTML-код
- Опубликовано: 8 июл 2024
- Support Me & More: linktr.ee/benthompsonuk
In this detailed video we go in-depth on copying data from one workbook to another. We cover three variations:
1) Simple Copy and Paste
2) Copy and Paste Only Values
3) Copy a Dynamic Range and Paste to Next Empty Row
Although this tutorial is longer than normal, we strongly suggest watching to the end to get the most from this detailed tutorial.
You can also download a copy of the exact workbook used in this tutorial from the link below!
As always, drop a comment if you have any questions and DON'T forget to LIKE and SUBSCRIBE 😃
Instructor Lead Excel Course ► essentialexceluk.com/products...
Download Workbook ► essentialexceluk.com/blogs/tu...
VBA Playlist ► essentialexceluk.com/blogs/tu...
More Tutorials ► essentialexceluk.com/blogs/tu...
#excel #vba #tutorial #copy #paste #macros
I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!
For More 👉 essentialexceluk.com/blogs/tutorials
Thank you so much! You were sent from heaven.
Oh my gosh, your explanation is so easy to understand! Thank you very much!!! This is such a great help! Thank you!!
Thank you! Glad you enjoyed 😃
Great!😍
Hello, very informative thank you! Rather than typing in the file pathway into the macro is there a way I can make it so looks up a specific cell which contains the specific file path required. Cheers!
OMG, I've tried soo many other ways and this one worked
So glad to hear you found this helpful!! 🙂
This is good. Been trying to find a code similar to what im trying to accomplish. I have multiple sheets all with the same data (columns are the same but rows which includes headers can vary). I wanted to see if i could get the same result by copying & pasting the same data from each worksheet source onto the same destination worksheet but all in the same workbook.
Hello. Thank you for a great video. May I ask you to advise how in the last code (using the look up function) I can paste copied figures as Paste Special? Thx
works great! 😅
Great video! On the third sub, how would you take new data and paste it into a new blank column in the destination sheet? So each time you read fresh data, it would grow to the right instead of down.
amazing how to deliver your information about that subject
go ahead
you have great content to share
Thank yo so much for the great help. I was able to successfully copy from one workbook to another. But unfortunately it didn't copy the dropdown part. Can you please suggest anything?
You're one of my favorites but my vision isn't what it used to be! A little larger would be nice.
Excellent video. I need some assistance. in above scenario the file name is static. How can we achieve copy and paste if destination file name is changing on daily basis. How can I still achieve to paste the data in new file? many thanks in advance
Can you assist how to add header into the above code which was already present in other excel sheet but in my case i want to add header using above code
How we can copy the data after applying filter on source file ? As the error comes due to changing of the row number in source file as its does not start from A2 and I am getting "Subscript out of range error". I have updated the CopyLastRow and destLastRow to long instead of integer, but still getting the same error
How can this be done on two files with one file name changing
this is good and it is VERY BASIC... What i would like to learn and know how to do is to grab and copy specific rows onto another Workbook that has multiple sheets.
So for instance, your data has United Kingdom, Australia, and United States. Lets say, you want United Kingdom on one sheet, United States on another, and Australia in a 3rd sheet.
The current macro you have will just copy all the data and paste it onto one sheet. What i would like to learn is how to get only the United Kingdom rows on one sheet, and the same thing for the others. To separate them and make the data that the end user would be looking at much more clean and more designated towards their department and so forth. How do we go about doing that?
Hi Kite, thank you for your comment! For this particular scenario I would lean towards using either power query or power automate rather than vba. Either of my suggestions would then enable you to easily extract and filter your source data then add / save where required.
VBA would be able to achieve this but both solutions mentioned above make the process a lot easier and with power automate, allow you to schedule this rather than requiring a manual touch. Hope that helps? We are currently working on videos of a similar scenario that should release in the next week.
@@EssentialExcel awesome, thank you for the information, I will go research 😃
please sent me vba code