Results 1 to 6 of 6

Search separate sheets to find matching model numbers and return results in another sheet

Threaded View

  1. #6
    Registered User
    Join Date
    02-17-2014
    Location
    Florida
    MS-Off Ver
    Excel 2016
    Posts
    62

    Re: Search separate sheets to find matching model numbers and return results in another sh

    For a little more clarification -

    1.) There are three project teams (A Projects, B Projects, C Projects)
    2.) Each team will work on different projects ("Project Description")
    3.) Each team *MAY* be impacting the same Model number of a device we sell
    4.) Need to identify which team (A,B,C) and what model number is being affected by separate projects

    It's like a project "overlap" identification tool. The results should be copied and placed into the "PROJECT MATCHES" spreadsheet for review.

    So the "search" criteria will be ever changing as it just needs to loop through to see if there are any "Duplicate" items/model numbers found across the three sheets (A, B, C).
    Last edited by Jay S.; 07-13-2018 at 09:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 06-29-2017, 08:00 AM
  2. [SOLVED] Search/find all worksheets return results on new sheet
    By Morleyb in forum Excel General
    Replies: 1
    Last Post: 06-28-2016, 03:51 PM
  3. Combobox value loop column lookup and return all matching results to a sheet
    By ToSonder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2016, 01:39 AM
  4. [SOLVED] Search a value then return a certain value from the separate sheet
    By ECYOJ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-31-2014, 01:33 AM
  5. Search a value then return a certain value from the separate sheet
    By ECYOJ in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-26-2014, 12:27 AM
  6. [SOLVED] Search Multiple columns for string, display matching results on different sheet.
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 06:53 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