In over my head, need some assistance with Excel for locating duplicate data

Hello,
I am regrettably in over my head with a project at work.
I am hoping someone can offer some vba assistance.

I have an excel workbook with four sheets.

Sheet one simply has just three columns of data (though many thousands of lines long)
Column A values represent the inventory (part number)-- column B represents
the qty ordered--and column C data represents the ship date.

Sheet Two is the same column and data set up but represents the inventory-qty-and ship date 24 hours later.

What I need to happen is to have Excel compare the sheet two data to the previous days data located on sheet one and populate sheet three with only the brand new customer orders. Can anyone help?

So.. in other words.. if the Inventory (Part Number) is on sheet 2 but NOT on sheet 1.. you want to show it on sheet 3?

Try something like this..

You can see it working in the attached Workbook.

Please Login or Register  to view this content.

Attach a workbook..
May be there could be a better non vba solution..

Don't forget to click *

Hello,

So if Sheet one has the following data:

COLUMN A COLUMN B COLUMN C
PART 1 9/3/2014 72

And Sheet Two has the following data:

COLUMN A COLUMN B COLUMN C
PART 1 10/7/2014 57
PART 2 9/26/2014 586
PART 1 9/3/2014 72


Line number 3 in Sheet Two has an exact match somewhere on sheet one, so it can be ignored. However lines 1 & 2 on sheet two are brand new (no match in sheet one) and I would like both new lines to copy to sheet 3.

Yea I'm going to attach a workbook tomorrow once I get into the office, will be easier to show what I'm looking at. Thank you all!!!!

Hi..

Line number 3 in Sheet Two has an exact match somewhere on sheet one, so it can be ignored. However lines 1 & 2 on sheet two are brand new (no match in sheet one) and I would like both new lines to copy to sheet 3.

My code should do exactly that.. did you try the attached Workbook.?

This is fantastic. You have saved me HOURS of time.

Thank you so much!