How to Copy Data from Another Workbook in Excel Using VBA

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 😃

#excel #vba #tutorial #copy #paste #macros

[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!

[magico_ideal]

Thank you so much! You were sent from heaven.

[sakura]

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

[bassguitarist]

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

[callumhayles]

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!

[mariarib]

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

[ahmedaiad]

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

[thomasmassie]

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.

[manci]

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

[hmylegs]

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.

[amritachopra]

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?

[rajeshdhanawade]

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

[krushnakumargajbhiye]

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

[Villgaxx]

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

[kiteflying]

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?

[shrum]

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