Hi everyone. This is my first post. Im relatively new to VBA, and i have a problem i need solved for the place i work.
The problem:
I have a workbook, with two sheets.
In Sheet1, theres alot of random client codes in colum A (approx. 50000). They look like this: 2002619458
In Sheet 2, coloum A, theres alot of clientnumbers too. From coloum B to AW, is alot of random information.
Now, i would like my VBA code to start in sheet one, top of coloum A, take that clientnumber, search for it in Sheet2 coloum A, and IF it finds it, copy that entire row to sheet3.
I've really googled this, and looked at other forums. I've found some code that might be helpful, but i simply can't see how to get it to work for me. I think the code below, is what comes the closest:
Hope you can help.
- Tobias
Bookmarks