searching rows and coloumns
Thanks Norman,
I used the Advanced Filter. It works almost fine.
The table I take the data from has some colors and boarders. I don't
want them. I tried to use ColorIndex:=xlNone, LineStyle:=xlNone inside
the autofilter sentence, but it gave an error. Is there a way?
Plus, I want to get the exact match. I searched for "IS", but the
filter also gave "IS 2" and "IS W".
|