+ Reply to Thread
Results 1 to 6 of 6

Linking a dropdown box to an array of filtered data

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Urbana, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Linking a dropdown box to an array of filtered data

    Greetings,

    I have an array of data that I want to be able to filter based on the selection in a dropdown box. For instance, If I select district manager, I want to show the data of only the people who are successors for district manager. For my own reasons I want to use this method rather than just applying the standard filters to the column headings. I have attached a sample workbook for anyone to work with.

    Thank you in advance for your assistance

    DummyData.xlsx

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Linking a dropdown box to an array of filtered data

    Hi,

    Something like in the attached?

    Regards
    Attached Files Attached Files
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    06-03-2013
    Location
    Urbana, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: Linking a dropdown box to an array of filtered data

    This is exactly what I need. Thank you. How come when I try to apply the formulas to my worksheet I keep getting prompted to select a file to update the data?...............

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Linking a dropdown box to an array of filtered data

    Well, of course the sheet names in the formulas I used (Filtered, Data and Lists) were only applicable to my particular workbook. I assume you've amended them accordingly?

  5. #5
    Registered User
    Join Date
    06-03-2013
    Location
    Urbana, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: Linking a dropdown box to an array of filtered data

    whoops ok I fixed that. However, with the amended formula it still doesnt populate the cells when I select a position. Any other suggestions?

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Linking a dropdown box to an array of filtered data

    I'd really need to see the sheet (or a sample therof) to be able to suggest anything.

    Regards

+ 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. Linking filtered data to other worksheets.
    By sajega in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-06-2013, 01:54 PM
  2. Help linking data to a dropdown/combo box
    By Chamberienne in forum Excel General
    Replies: 0
    Last Post: 04-18-2013, 08:40 AM
  3. dropdown-->selected value-->filtered view
    By bijunator in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2012, 11:38 AM
  4. Replies: 4
    Last Post: 09-04-2012, 06:09 AM
  5. Help needed for linking hperlink with filtered data across sheets
    By ashtest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2012, 12:29 PM

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