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

@EssentialExcel

Жыл бұрын

Thank you! Glad you enjoyed 😃

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

@EssentialExcel

2 жыл бұрын

So glad to hear you found this helpful!! 🙂

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

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

works great! 😅

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!

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

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.

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.

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?

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?

@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 😃

please sent me vba code

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