+ Reply to Thread
Results 1 to 4 of 4

Drop down menu with hidden values

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    nottingham
    MS-Off Ver
    Excel 2010
    Posts
    3

    Drop down menu with hidden values

    I am building a workbook which will be used to quote cleaning jobs and i want to add a drop down selection menu with hidden values which will help calculate timings for jobs - for example

    if you select DOOR WITH VISION PANEL i want that to have a hidden value that is the time it takes to clean e.g. 1 minute the auditor then enters the number of doors lets say 3 and the spreadsheet can then calcutalet that 3 doors with vision panels will take 3 minutes to clean

    can anyone help

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Drop down menu with hidden values

    You should look into building a lookup table

    If you want to hid the lookup table, there are many ways to go about it, all preference based...

    1) Create the table on another sheet and hide it
    2) Color the table white so it blends into the background
    3) Move the table to a location on the sheet way out of the way
    4) Imbed the table within the lookup formula
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    04-09-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Drop down menu with hidden values

    Jeff, what do you mean by your last point?
    Thank you.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Drop down menu with hidden values

    Take a look at this site and see if that helps...

    http://support.office.microsoft.com/...CEL&Version=12

+ 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. Replies: 0
    Last Post: 01-15-2013, 05:59 PM
  2. [SOLVED] Activating hidden sheet using a drop down menu
    By mando415 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2012, 08:40 PM
  3. [SOLVED] Drop-down list with hidden values
    By ExcelStefan in forum Excel General
    Replies: 4
    Last Post: 09-04-2012, 09:37 AM
  4. Unhiding hidden columns from a drop-down menu
    By TJBateson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2012, 05:11 PM
  5. Drop Down Menu Values
    By slvr98svt in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-07-2009, 10:29 AM

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