How to copy specific columns from sheet2 to sheet1 with dynamic rows. Columns are not continuous so I can't range it as column ("A:D") for example. My code below does copy the values but it takes longer as it is per cells and it's like looping. How can I copy it in the fastest way possible using vba?
Please Login or Register to view this content.
Last edited by dummy777; 06-04-2020 at 07:38 PM.
Re: How to copy specific column from one sheet to another
Hi,
for standard rows you can extract each desired column at once without any loop
Last edited by Marc L; 06-04-2020 at 10:35 AM.
It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi, I can't attached file as I'm using my computer in my workOriginally Posted by Mumps1
How can I do that without a loop? I will just modify my code in "For, Next"?
Re: How to copy specific column from one sheet to another
As it depends on how smart is the source worksheet - I'm a very beginner as mind-reader - with its regular rows
but yes a loop is useless as you can copy data column by column : if you operate manually, do you copy cell by cell or column by column ?!
As the easy way is to reproduce what you can already achieve manually just activating the Macro Recorder to get your own code base
If you need further help it seems you missed the top page yellow banner
Manually create a mock-up file at home with generic data that is organized in exactly the same way as your actual file. Perhaps you can use the original headers. Include just enough data to make the mock-up exactly representative of the original data. Then describe what you want to do in detail referring to specific cells, rows, columns and sheets, using a few examples from the data and attach the mock-up file here.
Re: How to copy specific column from one sheet to another
In the original code, two Variant variable are created as Worksheet object, used everywhere except in the Lastrow codeline ‼
So this Lastrow comes from the active sheet and as we can't guess which is the active sheet neither reading the initial 'explanation'
Based on your code, you could re-write it like below assigning the whole column data all at once instead of looping through each cell. If this still doesn't help, then I guess you have to post a sample file
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
Thank you once again nankw for helping me. It really works well.Based on your code, you could re-write it like below assigning the whole column data all at once instead of looping through each cell. If this still doesn't help, then I guess you have to post a sample file
Please Login or Register to view this content.
Glad to help & thanks for the reps
You're welcome!Glad to help & thanks for the reps
Also, how can I not include the headers in .Columns(3).value?
You can use Offset like below I have change the sheet1 to start from row #2 I guess
Please Login or Register to view this content.
Thank you very much, yes its working.You can use Offset like below I have change the sheet1 to start from row #2 I guess
Please Login or Register to view this content.
Please Login or Register to view this content.
This is the beauty of the forum where we all learn something new everyday
Please don't quote the whole reply, if necessary to quote, just quote the needed statement - Take couple of minutes to read the forum rules HERE
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks