+ Reply to Thread
Results 1 to 1 of 1

Search Workbook for cells that meet multiple criteria and return results from rows

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Gilbert, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    1

    Search Workbook for cells that meet multiple criteria and return results from rows

    I would like to search worksheets that are listed in a table of contents and create a list of search results with unique values only. The attached workbook shows an example of the results for the search criteria Ref ID's that begin with "AB" or "CD". The table of contents page lists the worksheet name and the location of the data corresponding to each worksheet. For example List All searches column A and extracts data from column A, D, B, E, & C and paste the data into column A, C, D, E, & H of the results page. I created the sample results page by using copy/paste and then filtering the data. My original data is too long to keep performing this operation. Any help would be greatly appreciated.

    Create_List.xlsx
    Last edited by Leith Ross; 06-27-2013 at 06:53 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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