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
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!
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.
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
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
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?
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.
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
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 😃
OMG, I've tried soo many other ways and this one worked
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
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!
works great! 😅
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.
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
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
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?
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 😃
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
please sent me vba code