+ Reply to Thread
Results 1 to 4 of 4

Dynamic List Creation

  1. #1
    Registered User
    Join Date
    01-23-2012
    Location
    Yverdon, Suisse
    MS-Off Ver
    Excel 2011
    Posts
    3

    Dynamic List Creation

    Hey All,

    I'm trying to create a list of values that are selected from the same drop down box. For example, you have a drop down menu of all services you provide to a customer. Upon selection of one, and a submit button it starts to generate two lists. The first list being the service you selected and the second list being the price of that service. I'd like to avoid VBA due to compatibility issues throughout the company but don't know if I can with this type of problem.

    Any solutions out there? I've thought of hide / unhide cells with a drop down list but this would cause issue if say a service was selected multiple times. Or perhaps a standard list with a field you check to include / how many items you wish and it pulls the lists together in a separate sheet.

    Open to thoughts or ideas!

    Thanks in advance for any help that can be provided!

    -toboredtosleep

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,180

    Re: Dynamic List Creation

    Like this?
    Attached Files Attached Files
    Last edited by Kyle123; 01-23-2012 at 12:58 PM.

  3. #3
    Registered User
    Join Date
    01-23-2012
    Location
    Yverdon, Suisse
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Dynamic List Creation

    Yes and no. You've got part of it. What would need to happen next, is say you choose service 2. It is displayed on the list you created to the right. Now when a user then selected, say service 1, it would need to add that service below "service 2" in the list. And this then would need to continue as many times as a new service was selected. If what I'm saying doesn't make sense, let me know and I'll try to give a better explanation. But we are on the right track!

    Best example, is a no VBA shopping cart...

    Thanks!

    -toboredtosleep
    Last edited by toboredtosleep; 01-24-2012 at 10:28 AM.

  4. #4
    Registered User
    Join Date
    01-23-2012
    Location
    Yverdon, Suisse
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Dynamic List Creation

    Double post, sorry.

+ 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