+ Reply to Thread
Results 1 to 3 of 3

Filter two columns based on cell values in another worksheet

  1. #1
    Registered User
    Join Date
    06-28-2017
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    2

    Question Filter two columns based on cell values in another worksheet

    As the title states, I need to filter two columns based on values that are input in another worksheet. One of the cells is a drop-down box. I want the filter to work so that if I type in "N1" for column A and "D1" for column B, only rows that contain both will be shown. Right now I am simply trying to find a code that works within one worksheet, but to no avail. It filters values, however it ignores previous filters applied (if I wrote N1, then D1, all values of D1 will be shown instead of only the ones corresponding to N1). I cannot figure out how to apply both filters at once. Here is the code I am currently using:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Filter two columns based on cell values in another worksheet

    Try

    Please Login or Register  to view this content.
    i changed the fields to 1 and 2, because the columns A en B

    Kind regards
    Leo

  3. #3
    Registered User
    Join Date
    06-28-2017
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    2

    Re: Filter two columns based on cell values in another worksheet

    Thank you, this works perfectly!

+ 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. Replies: 0
    Last Post: 10-08-2016, 05:31 PM
  2. [SOLVED] Filter for Unique Values based on Two Columns
    By jfried11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 09:48 AM
  3. Filter Table with values based in worksheet
    By delboy2405 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2013, 03:50 AM
  4. Replies: 2
    Last Post: 06-11-2013, 12:43 AM
  5. Filter rows based on cell values in multiple columns
    By dionaqld1 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-25-2012, 09:13 AM
  6. Replies: 2
    Last Post: 02-11-2010, 03:12 AM
  7. Filter based on values of multiple columns
    By learning in forum Excel General
    Replies: 8
    Last Post: 09-29-2009, 03:17 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1