Compare Two Columns Between Two Worksheets, keep duplicates, delete others, copy new

I've looked at many treads on this topic, but can't seem to get exactly what I need to happen. Here's the process I'm looking to perform:
-new data are imported to "import" worksheet from separate excel workbook
-old data are located in "master" worksheet
-Compare columns "E" & "J" for each row in both worksheets
-if match, keep row in "master" worksheet
-delete no-match rows in "master" worksheet
-copy remaining new data rows from "import" worksheet into "master" worksheet


This is what I've tried to start with. If there's a way to skip the "import" worksheet and just do the analysis during the import process from the separate excel workbook, that would be even better. Thanks for any assistance you can provide.
Scott

Please Login or Register  to view this content.