Help adapting an existing macro.

**paul1970** · 10-10-2008, 07:19 AM

Hi,
First of all this is a great forum and I can honestly say you've all taught me everything I know about VBA (2 whole days experience!).
Anyway, I've modified this macro I found on this forum, all it does is compares 2 lists of 6 digit serial numbers and and then tells me which numbers are in list 1 that are not in list 2.
However, I want to modify it so that it also gives me the numbers in list 2 that are not in list 1 (put into column F). I then need it to cut the matching serial numbers (in columns A and B) from sheet 1 and paste them into sheet 2.

Can anyone help?

Here's the code for what I have so far.

Please Login or Register  to view this content.

**martesoft** · 10-10-2008, 07:31 AM

Please Login or Register  to view this content.

**royUK** · 10-10-2008, 08:30 AM

Paul, please take more care that your Thread Titles convey a better idea of what you want in future. Read the Forum Rules to see why.

**paul1970** · 10-10-2008, 09:10 AM

Thanks Martesoft but it's not quite what I was after.

It does copy the duplicate serial numbers across to the second sheet but it doesn't remove them from the first sheet.

How is this done?

**royUK** · 10-10-2008, 09:28 AM

Please Edit the Title or I will lock the Thread!

**paul1970** · 10-10-2008, 09:50 AM

Sorry, but it's not an easy question to sum up in a couple of words.
Am I posting in the wrong section of the forum? If so, can you tell me where I need to post and then please delete this thread.