Results 1 to 1 of 1

how to create selectable multiple linked drop down lists that omit used items for menu

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2014
    Location
    perth
    MS-Off Ver
    2010
    Posts
    2

    how to create selectable multiple linked drop down lists that omit used items for menu

    Hello I hope i have posted in the correct section!! I have a complicated issue with a function menu i am trying to create for a offsite catering work! I have multiple canape menu's and set menu options in certain price points.

    The form needs to be idiot proof so that when i select a option box that is the only options that can be selected from. Also to complicate matter furthers when i have selected the menu options via the option box i require further data validation to omit selected items so that they are not entered twice.

    I have created a sample form with data required and fields where data validation is required however im not sure how to go about the rest or even if i have started correctly there is so many menu types and combinations that im unsure how to go about the validation.

    Also please disregard the sample form to the far right as this is a reminder as how i have to format the general appearance for later on!

    Help??
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Row Filters based linked to Button and Drop down menu
    By batchy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2013, 05:11 AM
  2. Multiple linked drop down lists (Master drop down)
    By zaalibhai in forum Excel General
    Replies: 1
    Last Post: 06-23-2011, 10:51 AM
  3. Replies: 4
    Last Post: 08-05-2010, 08:26 AM
  4. Drop down menu lists items from a table
    By Nate5452 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2007, 06:47 PM
  5. Drop Down menu & multiple linked cells
    By darken99 in forum Excel General
    Replies: 0
    Last Post: 06-05-2007, 01:03 PM

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