+ Reply to Thread
Results 1 to 9 of 9

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

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    23

    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
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

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

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-19-2014
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    23

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

    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"

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

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

    Did you even try the macro because that is exactly what it does? If it is going to be the same word everytime you can just hard code it in such as

    Please Login or Register  to view this content.
    Last edited by stnkynts; 09-19-2014 at 11:07 AM.

  5. #5
    Registered User
    Join Date
    09-19-2014
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    23

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

    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

  6. #6
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

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

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

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-19-2014
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    23

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

    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.

  8. #8
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

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

    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.

  9. #9
    Registered User
    Join Date
    09-19-2014
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    23

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

    Thanks a Ton

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create Macro to Search for specific word on separate sheet
    By papinj2004 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2014, 03:36 PM
  2. Replies: 8
    Last Post: 11-04-2013, 02:34 PM
  3. Macro to search and copy specific information on the next blank line.
    By jlo33 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2013, 01:58 PM
  4. Copy a line with a specific key word into another sheet.
    By kkihead in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-22-2013, 01:12 PM
  5. Search word and copy line from multiple sheet to single sheet
    By drtorn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2012, 01:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1