VBA code to copy and paste data in one sheet from multiple sheet and loop through
I am trying copy data in column B for all of the sheets for 2006-2013 to all years sheet. I tried making this code which only does for one year. Is there is any way i can automate this so that the copies data from all the sheets and paste in all years according to years. I am not really that good with VBA just learning. I want to keep using xldown for the code though as it is an requirement for my work
Please Login or Register to view this content.
Last edited by Farhasnat; 12-27-2021 at 08:38 AM.
Maybe this?
BSBPlease Login or Register to view this content.
I see the sheets for 2006-2013 are the same size, maybe this code:
Please Login or Register to view this content.
Thank you. This code works but the it repeats copying column A data repetedly also instead of pasting data horizontally it paste data after under let's say when pasting data for 2006 is done it put the ddata for 2007 right below it
Thank you so much. this perfectly works !Originally Posted by leonguyenz
I see the sheets for 2006-2013 are the same size, maybe this code:
Please Login or Register to view this content.
Last edited by Farhasnat; 12-24-2021 at 04:26 AM.
Thank you. This code works but the it repeats copying column A data repetedly also instead of pasting data horizontally it paste data after under let's say when pasting data for 2006 is done it put the ddata for 2007 right below itMaybe this?
BSBPlease Login or Register to view this content.
So you want the results pasted side by side rather in one long list?
BSB
Yes side by side only the numbers as the Column A11:A64 is same for every year. Also if I could add the year headers would be great.
BSBPlease Login or Register to view this content.
Thank you. I just tired to understand the code you sent understood every bit of it. Thank you !BSBPlease Login or Register to view this content.
Happy I could help.
Thanks for the rep and don't forget to mark the thread as SOLVED if you're happy you have a working solution.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks