+ Reply to Thread
Results 1 to 6 of 6

Create list of cells based on multiple criteria

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Create list of cells based on multiple criteria

    Hi everyone,

    Hope I can get some help. What i'm trying to do is develop a macro that will generate a list of cells from a data sheet based on specific information in the adjacent cells.

    Please see attachment. Example 1:

    Create a list of Activity numbers in sheet 1 from data in sheet 2 which have an H in the Letter column

    Example 2

    Create a list of Activity numbers in sheet 1 form data in sheet 2 which have an LLL in the attachment column.

    Any ideas?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Create list of cells based on multiple criteria

    Like this: Test.xls?
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Create list of cells based on multiple criteria

    tehneXus

    Thanks very much for the response. I searched H which seemed to work right, but when I searched LLL or WWW I didn't get anything. Any ideas?

  4. #4
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Create list of cells based on multiple criteria

    Hi,

    would you like to set the column to look in (Letter or Attachment) during the macro processing or should the program look for the value you insert in both columns?

  5. #5
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Create list of cells based on multiple criteria

    Hi,

    Actually, I can probably use the button you made for searching for H's and another button that searches for either LLL or WWW. I'm looking at your VBA code but i can't see to figure out how to adjust it so I cn have a separate button to search for LLL or WWW. Any help?

    Thanks!

  6. #6
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Create list of cells based on multiple criteria

    Hi,

    please try this one: Test_2.xls

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create a sub list into another sheet based on multiple criteria
    By icalculate in forum Excel General
    Replies: 3
    Last Post: 02-06-2013, 02:14 PM
  2. [SOLVED] Create a list that has more than one column based on a criteria
    By limebaish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-01-2013, 09:21 PM
  3. [SOLVED] Create a separate list based on criteria in another list.
    By dpitts21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2012, 07:09 PM
  4. MACROS: Sort by multiple criteria - Create tabs based off of criteria
    By svineyard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:48 AM
  5. [SOLVED] Create a list based on single shared criteria
    By David127 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-14-2005, 10:50 PM

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