+ Reply to Thread
Results 1 to 5 of 5

Search Multiple Worksheets Against List of Non-Exact Search Criteria?

  1. #1
    Registered User
    Join Date
    11-02-2009
    Location
    NYC, USA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Question Search Multiple Worksheets Against List of Non-Exact Search Criteria?

    Hi folks,

    I've spent a couple hours searching for a solution to this but came up empty handed. My macro/VBA skills are non-existent, so I hope that someone can help

    Here's the situation...

    I have a workbook with many many sheets in it.

    The first sheet contains a single column with about 10,000 different values. I'd like to use each of these as search criteria against ALL data in the other sheets (of which there are a good 50 or so).

    If matches are found (they don't have to be exact case), then I'd like two things to happen:

    1. The rows containing the matched search criteria in the first sheet are highlighted.

    2. In the cells adjacent to the search criteria in the first sheet, hyperlinks to the matched data are created and named after the sheet upon which this matched data appears.

    I've attached a sample file to this post with ideal sample 'answers' to queries made of the first 2 terms. Hope that helps somewhat in explaining the above!

    Thanks in advance.

    Best,
    Ian

    p.s. Just realized that the title of this post is misleading.. it's not 'non-exact search criteria', but rather, 'case insensitive search criteria'.
    Attached Files Attached Files
    Last edited by thump4r; 11-02-2009 at 04:51 PM. Reason: Clarity..! Bad posting title.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Search Multiple Worksheets Against List of Non-Exact Search Criteria?

    Welcome to the forum.

    Try this:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-02-2009
    Location
    NYC, USA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Thumbs up Re: Search Multiple Worksheets Against List of Non-Exact Search Criteria?

    Hi shg,

    Thank you so much for your prompt reply - I tried it against the test sheet and it worked perfectly with a slight tweak (changed the MatchCase statement to false).

    I'll give it a go on the real document now.... will let you know how it turns out!

    Cheers,
    Ian

  4. #4
    Registered User
    Join Date
    11-02-2009
    Location
    NYC, USA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Smile Re: Search Multiple Worksheets Against List of Non-Exact Search Criteria?

    Works great - my machine took a while to process the data, but the end result is a beautiful sight to behold. Thanks again :D

    Best,
    Ian

  5. #5
    Registered User
    Join Date
    12-13-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Search Multiple Worksheets Against List of Non-Exact Search Criteria?

    Quote Originally Posted by thump4r View Post
    Works great - my machine took a while to process the data, but the end result is a beautiful sight to behold. Thanks again :D

    Best,
    Ian
    Did you ever find the solution to your first question: 1. The rows containing the matched search criteria in the first sheet are highlighted.

    This solution is exactly what I need and the highlighting feature would be perfect.
    Thanks.

+ 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