Auto populating drop down lists/cells based on conditions

  • Re: Auto populating drop down lists/cells based on conditions


    OK - give me a few moments and I'll post a sample file here. :)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Auto populating drop down lists/cells based on conditions


    Right - give this a go. You must not override anything in columns F, G or H - I would suggest you protect these.


    Example tab 4 - start with a choice at the top of column E and the formulae do the rest. Anything you wish to override is added in E. The extra benefit is you can see at a glance which rows have had overrides applied.

    Files

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Auto populating drop down lists/cells based on conditions


    Let me know how you get on with it, please. :)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules