Copyin data from sheet to another if values are same

Originally Posted by AB33

Please use code tangs on your code

Please Login or Register  to view this content.

Could be changed

Please Login or Register  to view this content.

Assuminng that you have ten rows to copy

Please Login or Register  to view this content.

Be warned: I have been using the find function for a number of times. If your data is small, it works fine, but with large it is very slow as the code looks at every single row on both sheets

Thank you, there seems to be some issue, for this picks all the data from the first sheet. I tried to change sheets but at that point it prints only 2 rows, and there should be hundred (as sheet "first" has that many rows). Haven't yet been able to figure out

Sir,
Please do not reply with quote. It has not purpose, but clutters the space.
Could you please attach your sample? As long as you can cope with the speed, we can improve the code, but need to test it on your sample.
To attach a workbook, click advance, half way the page there is an attachment.

Ok, here is similar sample with the original code.

Sorry my bad, in this one the second sheets data is in column B. Other wise the same. And i'm not looking for similar rows, only cells to match.

In this case, sheet firts would have value ABC in some line. If the same value is in sheet second in some (other) line, I would need to copy that value, and rest of the sheet second's row, where this value is located. I hope this doesn't sound too confusing..

Please see amended code # 7.
I have found 62 rows matches
I have inlcuded colouring to see which rows have matches, but can easily remove it.
Try it and let me know

It is working, some issues (not finding the match) were caused by empty spaces at the end of the cells. Works now, thank you!

Please close now this thread if you are happy with the solution provided.
Go to the top- right -hand side of this page, Choose "Thread Tools", select Solved from the drop down menu