Without using VB, fastest I know is to use a vlookup.

if the entire row is the same, make it easy..

In a helper column, enter:

=VLOOKUP(A2,Sheet2!A:A,1,0)

Copy this formula all the way down.

Put on a filter, delete all #N/A, then locate(nonblanks)

Delete all visible rows.

Copy and paste remaining to the bottom of the 2nd table if you want all in
one.

"WMark" wrote:

I have two worksheets...and have merged them, for now, in an attempt to
identify the rows that are common to both. Those that are common to both
worksheets I want to delete from the merged file. Does anyone know how this
can be accomplished without sorting then manually deleting the matches?

Thanks in advance,