Variable Lists In Same Cell Controlled By Contents Of Another Cell

    I need to have different lists appear in a cell based on the contents of another cell which is also a list. In other words if the content of the first cell is A, list A appears in the second cell. If the contents of the first cell is B, then list B appears in the second cell, etc. Thanks.

    Re: Variable Lists In Same Cell Controlled By Contents Of Another Cell


    Hello, jcsw!
    To what kind of list are you referring? Is it a data validation list?


    Mac

    Re: Variable Lists In Same Cell Controlled By Contents Of Another Cell


    It is exactly what I need, but when I tested it, I'm getting the same list in B1, for both entries in A1. Maybe I'm doing something wrong. Thanks for your help.

    Re: Variable Lists In Same Cell Controlled By Contents Of Another Cell


    I initially tried in it Excel 2007. I'm afraid the new version doesn't support VBA macros. It works fine in Excel 2003. Thanks again for your help.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login