View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barry Jive Barry Jive is offline
external usenet poster
 
Posts: 1
Default Problems with filtering!!


Hi.

I need some held developing a macro that will do the following:

Filter data row by row for certain text but there's a catch - it mus
be able to look at one column and, if it does not find the text, loo
at another column before eliminating it.

Is this possible? I have written some very long-winded VBA code usin
Autofilter but I am getting lost in my own work. It seems like
relatively straight-forward function so I am assuming that there is a
easier way to do it.

Any help would be much appreciated.

Thanks,

Andre

--
Barry Jiv
-----------------------------------------------------------------------
Barry Jive's Profile: http://www.excelforum.com/member.php...fo&userid=2428
View this thread: http://www.excelforum.com/showthread.php?threadid=37893