Compare two sheets,copy and paste unique rows based on values in 2 columns

**ooggiemobile** · 03-31-2013, 02:18 PM

Hello,
I would like to compare 2 worksheets in the same workbook, sheet 1 and sheet 2, and copy and paste rows from sheet 2 to sheet 1 if the combined value of 2 columns are not found in sheet 1.
I have attached an example to illustrate. Column B or D on their own may not be unique but when combined they would be.

I could also create an additional column and contcatenate B and D to provide a single column for comparison.

I am relatively new to this forum and VBA but consider myself a strong excel user. I have spent alot of time searching for existing posts that would help me find a solution but with no success.

Any assistance would be greatly appreciated

**AndyLitch** · 03-31-2013, 03:49 PM

Try this

Please Login or Register  to view this content.

**AB33** · 03-31-2013, 07:39 PM

As an option

Please Login or Register  to view this content.

**ooggiemobile** · 04-01-2013, 06:00 PM

Thank you both for your solutions. Both worked perfectly. I'll go to work to try to understand them now.

All the best...

**AB33** · 04-02-2013, 03:58 AM

ooggie,
You are welcome!
Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.