+ Reply to Thread
Results 1 to 5 of 5

search for string copy to new worksheet for multiple worksheets

  1. #1
    Registered User
    Join Date
    05-15-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    12

    search for string copy to new worksheet for multiple worksheets

    Hi,

    I need help writing a macro.

    Basically I have about 30 worksheets in each workbook, and in column B of each worksheet there are a bunch of codes listed. Some of the codes are only numbers whereas the other codes are prefixed with 'Bar' as the front...

    so some will look like this '23503252' and others will look like this 'Bar93222'

    The macro needs to be able to find the codes beginning with 'Bar', copy the entire row, and paste the entire row onto a NEW worksheet called "result" or summary....

    I have uploaded a sample workbook with some data in 3 worksheets and a results spreadsheet which I have populated so you can see what the result should look like (but my real workbook will have around 30).

    Thanks in advance! please help!

    Cheers,

    Dexter
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: search for string copy to new worksheet for multiple worksheets

    This should do it:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    05-15-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: search for string copy to new worksheet for multiple worksheets

    THANK YOU!

    Works perfectly! And thanks for replying so quickly!

    Cheers,

    Paul

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: search for string copy to new worksheet for multiple worksheets

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  5. #5
    Registered User
    Join Date
    09-05-2011
    Location
    Delhi
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: search for string copy to new worksheet for multiple worksheets

    Hi,
    I have a similar problem.I have workbook with round 20 sheets..I want to copy the results of ctrl+ f "tryit" to a new sheet.The ctrl+f highlights the rows of search result in every sheet but i want to copy all the results directly to one sheet without going to each and every sheet and copy results. Please help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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