Comparing two worksheets and copy non matching rows

**thylander** · 07-18-2011, 04:27 AM

Hi guys,

I have this code to compare two worksheets and copy the rows that are missing in the activesheet from the next sheet.

Please Login or Register  to view this content.

This code works great BUT here is the tricky thing though that I need your help with.

if there is a match, I want to copy the values in columns 10 to 14, 16, 19 to 23, 25, 28 to 32 and 34). So the values in the source worksheet ends up in the right column in the destination worksheet.

i'm attaching a workbook that shows what I mean. All help/ideas is appreciated.

Looking forward to your help with this issue!

**realniceguy5000** · 07-18-2011, 07:55 AM

See if this gets you any closer to where you want to be.

Please Login or Register  to view this content.

**thylander** · 07-18-2011, 09:17 AM

Thanks for the help,

Easier then I thought

**KNevland** · 08-03-2012, 03:40 AM

Hi!

This macro does almost exactly what I am looking for. But instead of using the active sheet and the one next to it as destination and source, is it possible to use two spesific sheets instead?

Also, instead of checking the entire sheet can we implement a range i.e. Column A to I. So that the macro only check and insert information from that range?

**arlu1201** · 08-03-2012, 03:43 AM

KNevland,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.