+ Reply to Thread
Results 1 to 5 of 5

Drop down list set to default sum but blank when row is blank

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    Annapolis, Maryland
    MS-Off Ver
    Excel 2007
    Posts
    85

    Drop down list set to default sum but blank when row is blank

    Hello. I hope someone can help me.

    I have rows of six columns, the forth of which is a drop down of percentages. I have chosen one of those percentages to be default (66%). However, I don't want that 66% to be visible unless there is something in another cell. Example:

    Column B is a Materials List
    Column C is Quantity
    Column F is Markup and has data validation set to a list with markups from 25% to 75%. I want 66% to appear every time a material is added to Column B. Then if the markup is less or greater, the drop down can be used.

    Any ideas? Thanks!
    Last edited by debbiesh; 02-21-2012 at 10:17 AM.

  2. #2
    Forum Contributor trucker10's Avatar
    Join Date
    07-22-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003 / 2007 / 2010 prof +
    Posts
    149

    Re: Drop down list set to default sum but blank when row is blank

    something like this ? dropdown list in column F , formula also in column F
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-08-2009
    Location
    Annapolis, Maryland
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: Drop down list set to default sum but blank when row is blank

    Argh, your sheet works great but I can't get it to work on mine. I get "Value not valid, restricted values..." error.

    Edited to add: It's .xlsm file.
    Last edited by debbiesh; 02-20-2012 at 02:07 PM.

  4. #4
    Forum Contributor trucker10's Avatar
    Join Date
    07-22-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003 / 2007 / 2010 prof +
    Posts
    149

    Re: Drop down list set to default sum but blank when row is blank

    Take a look to the validation
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-08-2009
    Location
    Annapolis, Maryland
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: Drop down list set to default sum but blank when row is blank

    Got it! Thanks so much!

+ 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