fiter and delete
 

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?

fiter and delete
 

Without all them? That just about removes all options, except maybe Filter.

Go into DataFilter<Advanced Filter and look at your options there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TUNGANA KURMA RAJU" wrote in
message ...
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?

fiter and delete
 

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