+ Reply to Thread
Results 1 to 3 of 3

Thread: Filter data in one tab based on drop down selections in a different tab

  1. #1
    Registered User
    Join Date
    01-07-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Filter data in one tab based on drop down selections in a different tab

    I need to determine how to filter a tab based on criteria selected from another tab. I know hoe this would be done in Access vb but cannot figure out how to do in excel.

    I've attached an example spreadsheet - seletions are made in the the first tab via drop down lists and radio buttons. I want the second tab to filter based on the selections in the first tab.

    Any help is greatly appreciated - thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    02-15-2008
    Location
    Grappenhall, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    6,566

    Re: Filter data in one tab based on drop down selections in a different tab

    Hi,

    Does the attached help?
    Attached Files Attached Files
    Richard Buttrey

    If this was useful then please rate it appropriately.

    Click the small star icon at the bottom left of my post.

  3. #3
    Registered User
    Join Date
    01-07-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Filter data in one tab based on drop down selections in a different tab

    So far - it looks like it does---THANK YOU for such a quick reply!
    I'm sure I'll have more as I develop more.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0