Results 1 to 5 of 5

Filtering data using Data validation list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-08-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    101

    Filtering data using Data validation list

    Hey guys,

    I am not sure if this is possible, but, I am trying to populate a table based on a selection in a Data validation List. I have attached a Sample file showing what I am trying to achieve. The sheet "Data" has a set of data and sheet "Filter" is where I need to have the filtering happen based on "Region". When I select "East" the table should populate all the rows with region "East" and the same should happen for other regions as well. Is this even possible in excel with VBA or something?

    Any help is appreciated.

    Thanks in advance

    VJ
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  2. [SOLVED] How do I link Dropdown List (data validation) with filtering data from a table?
    By Trishux25 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-29-2015, 10:17 PM
  3. Replies: 1
    Last Post: 07-29-2015, 08:36 PM
  4. Replies: 10
    Last Post: 06-10-2014, 05:35 AM
  5. Data validation list - logical filtering
    By Lizlien in forum Excel General
    Replies: 6
    Last Post: 10-24-2013, 03:13 PM
  6. [SOLVED] How to use value in cell after filtering data, using data validation list method
    By SAGAR KHOLLAM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2012, 02:01 AM
  7. Replies: 3
    Last Post: 05-15-2011, 11:46 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