Mudraker,

WOW!!
It worked.

I request little more help from you.
(a)In your macro we are searching for only for one string 'HONDA'. But i have 5 to 10 strings that i have to search for? Also these strings are almost same all the time. So instead of inputting each time, we can hardcode them in the macro itself. Please guide me how to change your macro to accommodate this.

(b)Apart from this couple of other VBA basic questions( i am new to VBA)
If i want 90 days prior date to today i.e Today-90 days in MM/DD/YYYY format, which i will later use in the FIND string, how to get date into a variable?

(c)Using autofilter, how to refer to the column name rather than the field number for example, the following works.

Selection.AutoFilter Field:=27, Criteria1:="=BB-LL", Operator:=xlAnd
How to replace Field:=27 with Field name=rec code ?

(d)Using autofilter how can i specify more than 2 Criterias for a Field?
If i have 10 different criteria's for a field, can i create Criteria1 thru Criterial10?

Again thanks for your help.

Regards,
akondeti