I'd use a helper cell.

In sheet1 cell B1, put this:

=isnumber(match(a1,othersheet!a:a,0))

and drag down.

Filter on that list. Show the rows with False and delete those visible rows.



TUNGANA KURMA RAJU wrote:

comparing a worksheet1 range(A:A) values with othersheet range(A:A)
values,and if value not found in othersheet,delete all row values from the
sheet1, without creating a separate sheet.vba code or function?

--

Dave Peterson