+ Reply to Thread
Results 1 to 6 of 6

Displaying or filtering Data based on a drop down selection

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    4

    Displaying or filtering Data based on a drop down selection

    Hi everyone, im new to the forumn , and honestly kind of an excel newb

    I'm doing a competitive comparison form for work and im having a little trouble.

    Basically I have a form setup with direct cross over , so package A = package 1, but extrapolated over 200 rows. At the top I have created a drop down list of the packages,using data validation, and I would like it if when they selected one package it would only show that package in the column, rather than all the packages.

    I have a feeling a may need to use visual basic to do it, but if I dont that would be great because i dont know how.

    Thanks

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: Displaying or filtering Data based on a drop down selection

    hmm. can you post an example? i think you will actually be able to do this w/o VBA using standard filters (or maybe a pivot table). Can see what i can do if you can post :D
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    03-11-2013
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Displaying or filtering Data based on a drop down selection

    I will upload one oncei get home from worktoday, my office firewall wont allow me to

  4. #4
    Registered User
    Join Date
    03-11-2013
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Displaying or filtering Data based on a drop down selection

    sample work book.xlsx


    sorry it took so long to link sample some family emergencies stopped me from getting home last night

  5. #5
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: Displaying or filtering Data based on a drop down selection

    Ok, I have two questions -- am I correct on the following assumptions:

    You want to use different names for the same product, depending on the company?

    These is some commons internal name for the products (which you can use as a key) that you would like to show in the "Lists" worksheet in place of the company-specific names?
    Last edited by GeneralDisarray; 03-14-2013 at 08:46 AM.

  6. #6
    Registered User
    Join Date
    03-11-2013
    Location
    Vancouver
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Displaying or filtering Data based on a drop down selection

    No unfortunately unlike the example the Packages are not quite as transferable in some cases some products arent carried but one company or the other.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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