+ Reply to Thread
Results 1 to 5 of 5

I need to search for a word on multiple sheets and copy the entire row to a new sheet

  1. #1
    Registered User
    Join Date
    08-25-2013
    Location
    us
    MS-Off Ver
    Excel 2010
    Posts
    3

    I need to search for a word on multiple sheets and copy the entire row to a new sheet

    Below is the code I am using. It works fine if I direct it to a singular page, but I would like it to look at all of my pages and them copy and past the rows that say fail to a new sheet.
    This code is looking to the sheet called Lighhouse. I have sheets called Docsis,XM2 6 Batt,XM2 8 batt,XM2 3 Batt, XP batt, XM2 Batt. I hope someone will be able to guide me to the lines I need to add to make this work. The tab called Failed Test is where I run and populate the data. Thanks for any help you can give me.


    Please Login or Register  to view this content.
    PowerSupplyTest.xlsm
    Last edited by arlu1201; 08-25-2013 at 10:51 AM. Reason: Use code tags in future.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: I need to search for a word on multiple sheets and copy the entire row to a new sheet

    Hi jkm,

    This is untested:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    08-25-2013
    Location
    us
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: I need to search for a word on multiple sheets and copy the entire row to a new sheet

    Worked perfect Thanks for all your help.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: I need to search for a word on multiple sheets and copy the entire row to a new sheet

    You're welcome! But, I'm concerned about there being more than one "Fail" entry in a row - could that become an issue??

    Anyway - if you're happy then please mark this thread as solved.

  5. #5
    Registered User
    Join Date
    08-25-2013
    Location
    us
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: I need to search for a word on multiple sheets and copy the entire row to a new sheet

    Quote Originally Posted by xladept View Post
    You're welcome! But, I'm concerned about there being more than one "Fail" entry in a row - could that become an issue??

    Anyway - if you're happy then please mark this thread as solved.


    " no there is only one column that has fail on it . I have modified the sheet so all the sheets look the same. Automation in process."

+ 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. Search string in a column then copy entire rows to another sheet
    By vannylette in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2013, 12:16 PM
  2. [SOLVED] HELP PLEASE : How to make macros to search a word in the entire sheet & c/p the value
    By kinabuch0902 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-26-2013, 11:36 PM
  3. 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
  4. Search for Multiple String Values on Multiple Sheets and Copy Rows to New Sheet
    By rrtikker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 12:21 PM
  5. VBA Search workbook for user value, copy/paste entire row to last sheet for matching
    By jasonkrispy21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2012, 03:42 PM

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