vba Match Two Sets of Data

**timbo1957** · 03-21-2011, 08:47 AM

I have two worksheets both with codes in column B I'll call them wksht 1 and wksht2.

I need a macro to run down the codes in wksht2 and match them to wksh1 and if there are any codes on wksht 2 that are not on wksht2 paste them into wksht3.

Many thanks.

**JBeaucaire** · 03-21-2011, 09:16 AM

1) Is B1 a title on each sheet? Data starts in B2?
2) What other columns are being used, if any?

Are you sure you need a 3rd sheet, the AutoFilter can be used to show you the non-matching values right on sheet2 without creating a 3rd sheet.

**timbo1957** · 03-21-2011, 09:36 AM

The data starts in row 9 in wksht1 and row 8 in wksht2.

Having a third worksheet is best because when I am on leave someone else can run the macro and see at a glance any new codes that need to be added. Non many know how to use Autofilter.

**JBeaucaire** · 03-21-2011, 09:43 AM

You saw both questions, yes?

Better yet, click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook. Let's just work on the sheet directly.

**timbo1957** · 03-21-2011, 10:25 AM

Sorry, see attached. I want to match the master priam report to the download report and anything in column B on the download report that isn't in the priam report to appear on a seperate worksheet.

I have cut the size of the worksheet down for posting purposes. It is usually 650 + rows long.

**watersev** · 03-21-2011, 11:58 AM

hi, timbo1957, one of the options to obtain the result you need, run code "test". Please note, sheet names are hard-coded. if you change them the code will need changes as well.