Hi, I found this piece of code. that copies data between 2 workbooks based on criteria in column A. It works, but there are two problems:
1. Since is looping through data and I have a few thousands, it is taking quite a while;
2. It should paste the data as values.
Can it be improved?
Please Login or Register to view this content.
Click the * to say thanks.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you Alpha. I have a problem. What I am trying to do is to copy range E-S from W1 into F-T W2 based on criteria in A. I've changed the ranges in your macro, and for columns F-M it works, but for the others returns N/A. Any thoughts on this?
Please Login or Register to view this content.
Thank you. Solved my issue
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks