Results 1 to 4 of 4

Filtering a column using a list for criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Rapid City, SD
    MS-Off Ver
    Excel 2010
    Posts
    11

    Filtering a column using a list for criteria

    Hey guys, this may be a difficult problem to explain, but I'll give it a try. I have attached an example, too.

    I have a column that contains a list of names (Sheet1) and a column on another sheet (Sheet2, column C) that I want to use the filter to see where that column (C) contains those names. So basically I want a filter that searches for variable text (defined on Sheet1) without typing in that text for each name individually for the filter.

    When the filter is on, I want the macro to copy the information from the columns labeled Data1 and Data2 (A and B) and paste them to right (as shown in red in the example).

    Don't feel obligated to do the whole thing, but any suggestions would be a great help.

    Thanks!
    Attached Files Attached Files

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