+ Reply to Thread
Results 1 to 4 of 4

Drop down list must be entered before another cell can have information

  1. 12-09-2015, 11:16 PM #1
    deraj
    deraj is offline
    Registered User
    Join Date
    10-28-2015
    Location
    New Zealand
    MS-Off Ver
    2013
    Posts
    8

    Drop down list must be entered before another cell can have information

    expense & visa claim.xlsx

    Hi Guys,

    Find attached my expense sheet that is almost ready to send out to staff.

    In short I would like it so that the dropdown list in column G must have an option selected in order to be able to enter values into columns H and I.

    Currently we have data validation in Column H =$G8="MILEAGE" (this has stopped entering into this column if mileage is not selected). The data validation in column I is =$G8<>"MILEAGE"... For some reason when I enter a value into the I column it is accepting it and not bring up an error (when nothing is selected in G column)... Is this because it is also counting the "blank" cell as <> Mileage therefor accepting the value you put in?

    Any help around this would be amazing!

    Thanks
    Reply With QuoteRegister To Reply
  2. 12-09-2015, 11:54 PM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Drop down list must be entered before another cell can have information

    yes i believe so
    i re-jigged your data validation in column I and H so that is G is empty it wont let you put anything in

    H8 DV changed to
    =OR($G8="MILEAGE",ISBLANK($G8)=FALSE)

    I8 dv changed to
    =AND(ISBLANK($G8)=FALSE,$G8<>"Mileage")

    *make sure to uncheck ignore blanks*
    which i did in the file but forgot to mention
    thanks JeteMc for reminding me about that
    Attached Files Attached Files
    Last edited by humdingaling; 12-10-2015 at 12:53 AM. Reason: forgot to mention the ignore blank checkbox
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 12-09-2015, 11:58 PM #3
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,597

    Re: Drop down list must be entered before another cell can have information

    For column I: 1) Uncheck Ignore blank 2) Use the formula 
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  4. 12-10-2015, 12:17 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,945

    Re: Drop down list must be entered before another cell can have information

    Set up those other 2 columns with Data Validation using this...
    =$G8<>""
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Single Cell Value From Either A Drop Down List Or Entered Manually, Depending On Selection
    By tackyjan in forum Excel General
    Replies: 1
    Last Post: 06-22-2014, 02:39 AM
  2. [SOLVED] Lock specific cells once a value is entered with a drop down list
    By MissDB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-26-2014, 08:41 AM
  3. Help with list box drop down returning muliple cell information
    By BobboExcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-05-2014, 05:39 AM
  4. Cell specifies a drop down list based on information in another cell
    By rmvdwalt in forum Excel General
    Replies: 1
    Last Post: 02-21-2012, 05:49 AM
  5. Excel 2007 : Trying to display a drop down list when a number is entered into a cell
    By jdonald1974 in forum Excel General
    Replies: 3
    Last Post: 10-04-2009, 10:56 PM
  6. VB to activate list drop-down boxes when data is entered in a cell
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-22-2009, 12:01 PM
  7. Limit data entered to list (drop-down control)
    By Ronnie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2006, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1