How to Copy Data from Another Workbook in Excel Using VBA

[@EssentialExcel]

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

[@magico_ideal]

Thank you so much! You were sent from heaven.

[@sakura0291]

Oh my gosh, your explanation is so easy to understand! Thank you very much!!! This is such a great help! Thank you!!

[@EssentialExcel]

Thank you! Glad you enjoyed 😃

[@bassguitarist2686]

OMG, I've tried soo many other ways and this one worked

[@EssentialExcel]

So glad to hear you found this helpful!! 🙂

[@ahmedaiad3372]

amazing how to deliver your information about that subject go ahead you have great content to share

[@mariarib6504]

You're one of my favorites but my vision isn't what it used to be! A little larger would be nice.

[@callumhayles5511]

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!

[@harilibo]

works great! 😅

[@sankharajapaksha]

Great!😍

[@thomasmassie1372]

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.

[@shrum1548]

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

[@0hmylegs]

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.

[@39manci]

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

[@amritachopra4765]

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?

[@kiteflying9317]

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?

[@EssentialExcel]

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.

[@kiteflying9317]

@@EssentialExcel awesome, thank you for the information, I will go research 😃

[@rajeshdhanawade4141]

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

[@krushnakumargajbhiye2871]

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

[@Villgaxx07]

How can this be done on two files with one file name changing

[@abdurrazzak8440]

please sent me vba code