fiter and delete

  • Thread starter TUNGANA KURMA RAJU
  • Start date
T

TUNGANA KURMA RAJU

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?
 
B

Bob Phillips

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

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

--

HTH

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

Dave Peterson

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.
 
Top