Hi,
I have a text file which i will import into xls.
Once imported i am only interested in rows that have specific keywords in any
of its columns.

How to search for a string let us say 'HONDA' in the entire xls(across all columns and rows) and save only those rows containing the searched string, to a separate xls file?

I have 5 to 10 keywords to search.

I want the +ve result of all the above searches to be saved to a different xls.

How can i do this?

Thanks a lot. I am new to excel VBA.

Regards,
akondeti