Results 1 to 3 of 3

Thread: Cascading Dynamic Drop-down Filter List With Concatenated Values Result In One Cell

  1. #1
    Member
    Join Date
    Jun 2013
    Posts
    52
    Rep Power
    11

    Cascading Dynamic Drop-down Filter List With Concatenated Values Result In One Cell

    I have managed to create a decent drop down system using linked cells or indirect linked cells, however now I have an issue where the extra cells are taking up way to much space on the sheet. The idea was to allow easy part# entry into the form. You would first select the type manuf. and then the type of device and finally the part number. To do this was taking up three cells when all I needed was the part number and that's it. So what I was wondering was if it is possible to have all this information in a cascading drop box selection and inputted into one cell.


    Example


    Manufacturer
    EST
    --------------Type
    PHOTO
    ---------------------------PART#
    SIGA-PS (This in the only information that is needed) if possible the Manufacturer name could also be included in the cell as well so the final cell would read


    EST SIGA-PS
    or just
    SIGA-PS


    The way it is set up right now I have to use a total of 3 cells just to get a simple part number. I'm really not sure where to begin on this one, as everything I have seen online shows indirect linked cells as the example.

    Thanks

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    William, to have the results of multiple drop-downs in the same cell (and concatenated), you'll need to use VBA. The other option of course would be to like the cell where you need the final result with the individual linked cells of the respective drop-downs.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    Jun 2013
    Posts
    52
    Rep Power
    11
    Could you give me a little more information on creating VBA for this function? I have a sheet labeled "Parts List" and all the parts are organized on that list.

Similar Threads

  1. Dynamic Dependent Dropdown List Filter
    By william516 in forum Excel Help
    Replies: 2
    Last Post: 07-09-2013, 09:21 PM
  2. Change Data Series In Chart Using Drop-Down List
    By raybugge in forum Excel Help
    Replies: 2
    Last Post: 07-06-2013, 03:02 PM
  3. Change Pivot Table Data Source Using A Drop Down List
    By hanishgautam in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-05-2013, 09:33 AM
  4. Replies: 2
    Last Post: 04-14-2013, 09:15 PM
  5. List Unique Values Using Formula
    By LalitPandey87 in forum Excel Help
    Replies: 5
    Last Post: 01-09-2012, 08:39 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •