I know the Excel help says to try to have only one list per sheet, but how silly a limitation is that?? And does anyone know of it to be a genuine problem with Excel?
I have 4 simple lists in my worksheet. 2 of them get their values from one manually typed set of data, the other 2 from another manually typed set of data. THey work fine by selecting the popup triangle and choosing from the list. However two of the lists (same set of data) will also let me simply type in a value, and if it matches data in the list it selects that data. The other two lists will not let me type in manually, they say a user has restricted the type of data that can be entered, though I can choose the identical data from the list myself.
????
One confused guy...
Jonathan
This message was edited by vanclute on 2002-10-24 22:26
I have 4 simple lists in my worksheet. 2 of them get their values from one manually typed set of data, the other 2 from another manually typed set of data. THey work fine by selecting the popup triangle and choosing from the list. However two of the lists (same set of data) will also let me simply type in a value, and if it matches data in the list it selects that data. The other two lists will not let me type in manually, they say a user has restricted the type of data that can be entered, though I can choose the identical data from the list myself.
????
One confused guy...
Jonathan
This message was edited by vanclute on 2002-10-24 22:26