Need a Macro that search a specific word and copy line to another sheet

Hi,

I am having a problem with Excel that I was hoping someone could help me with.

I have a table (attached) where between columns A to C are a number of tags. What I would like to do is have a function or a macro or something that will allow me to look within "cell A" for specific word & copy column A to C to another Sheet.

Some of the specific words are below & also would be adding more words to it.
Logistics
Amfico
Cargo
Dachser
Freight
Kuehne
Container
Transport
Movers
Schenker
Forwarders
Transworld
Rohlig
Worldwide
Marine
Global
Transline
Carrier
Balmer
Lines
Exim


Thanks in advance for your help

Please Login or Register  to view this content.

Hello,

Thanks for your help, but i need to search for each specific word every time, i am looking for a macro should automatically search in the Sheet A for the Specific words & give the inputs in "Sheet 2"

Its searches for the word i type & copies the details to another sheet, i am looking for a macro which automatically search for the specific word & copies without typing the words (words should be included in macro"
Is this possible

I told you how to do it in my previous post. Change the line:

Please Login or Register  to view this content.

How to input multiple words as this string searches only for one word, I need to add all words in 1 macro & which can give me desired results.

Added functionality for multiple search strings. Add your strings to the array as desired following the format.

Please Login or Register  to view this content.

Thanks a Ton