Simple VBA script for match Copy/Paste

Hi,

I am looking for a simple VBA script that can copy and paste.
I want it to match Sheet1 A1:6000 to Sheet2 A1:8000.
If match is found in Sheet2 copy the row(not only the cell) from Sheet2, in to Sheet3.


I have goggled but cant find a script that dose this, only match words.
And my VBA script skills are low, so I cant code it my self

Hi,

I am looking for a simple VBA script that can cut and paste.
I want it to match Sheet1 A2:6000 to Sheet2 A2:8000.
If match is found in Sheet2 cut the row(not only the cell) from Sheet2, in to Sheet3. And delete the enter row in Sheet1.

Note: there are duplicates in column A in both Sheet1 and Sheet2. I need them all moved to Sheet3 that's why I need them to be cut and pasted.

I have goggled but cant find a script that dose this, only match words.
And my VBA script skills are low, so I cant code it my self.

If there is any possibilities to also copy cell D&E from Sheet1 the row that it has found as a match in, to Sheet3 would be great. but not a must at this point.

Hope that someone can assist me.I have added a example of the file I use, this maybe clarifies my request.

Hopefully this is simple enough

Please Login or Register  to view this content.

Your two threads have been merged.