+ Reply to Thread
Results 1 to 10 of 10

search multiple worksheets in workbook for keyword then copy entire row to new worksheet

Hybrid View

sck22 search multiple worksheets in... 06-20-2012, 07:12 PM
smuzoen Re: search multiple... 06-20-2012, 10:16 PM
sck22 Re: search multiple... 06-21-2012, 07:53 PM
smuzoen Re: search multiple... 06-22-2012, 12:27 AM
sck22 Re: search multiple... 06-22-2012, 03:19 PM
smuzoen Re: search multiple... 06-23-2012, 01:45 AM
sck22 Re: search multiple... 06-24-2012, 02:23 PM
rjfnc Re: search multiple... 11-23-2012, 10:17 AM
arlu1201 Re: search multiple... 11-23-2012, 01:40 PM
rjfnc Re: search multiple... 11-25-2012, 02:22 AM
  1. #1
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: search multiple worksheets in workbook for keyword then copy entire row to new workshe

    I have changed the code to match your workbook. In the information sheets (Place 1, Place 2 etc) if this how you have the information stored then the code will produce the search results formatted the way you had in your sample. The FindAll function is designed to find EVERY occurrence of the keyword you are searching for and this function will allow you to do this by passing the required parameters and if you want the optional parameters. What it returns is all the ranges that contain the keyword so you just need to iterate through this to find each discrete range and then write the data to the output sheet.
    Attached is the revised workbook.
    If you have any problems or questions just ask.
    PS: If this is the first lot of VBA code you have written you were certainly on the right track and I am impressed for a first go. Well done!
    Attached Files Attached Files
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?

+ 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