+ Reply to Thread
Results 1 to 3 of 3

Want to Filter column data on Sheet 2 based on matching drop down selection on Sheet 1

  1. #1
    Registered User
    Join Date
    04-11-2011
    Location
    Detroit Michigan
    MS-Off Ver
    Excel 2003
    Posts
    2

    Want to Filter column data on Sheet 2 based on matching drop down selection on Sheet 1

    Want to Filter data on Sheet 2 Column B based on matching drop down selection on Sheet 1 A1
    Sheet 1 A1 contains drop down list (text)
    Sheet 2 Column B contains text

  2. #2
    Forum Contributor
    Join Date
    08-25-2015
    Location
    Near Pittsburgh, PA
    MS-Off Ver
    Excel 2013
    Posts
    152

    Re: Want to Filter column data on Sheet 2 based on matching drop down selection on Sheet 1

    I'm not real clear what you want, nor what your data looks like. The answers to a few questions might get us both on the same path

    - Can you describe your data better than you have, and what your drop down list looks like.
    - Can you describe what your end result would look like.
    - Can you give a brief "why" you want the results you want.

  3. #3
    Registered User
    Join Date
    04-11-2011
    Location
    Detroit Michigan
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Want to Filter column data on Sheet 2 based on matching drop down selection on Sheet 1

    Sheet1 cell A1 contains a drop down list of "Round", "Oval", "Square" & "Flat"
    Sheet2 columnA contains various part #'s. ColumnB contains either "Round", "Oval", "Square" or "Flat".

    I'm looking to filter sheet2, based on the drop down selection of Sheet1 cell A1.
    I also plan on using formula for other scenarios.

+ 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. Filter data on a sheet based on a drop down from another sheet
    By SR46 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2015, 07:57 PM
  2. filter and copy filtered data to another sheet based on combobox selection
    By prince82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2015, 11:09 PM
  3. Display Column in Sheet Based on Drop-Down List Selection
    By huntethic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2015, 01:11 PM
  4. Replies: 2
    Last Post: 04-02-2015, 06:46 AM
  5. Copying data to another sheet based upon YES/NO drop-down selection
    By Tsonga in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2014, 09:05 AM
  6. Transferring data based on drop down selection to another sheet on the same workbork
    By misswendyloo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2013, 12:44 PM
  7. [SOLVED] Looking for an easy way to change data on a sheet based on drop-down selection
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 09:39 AM

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