I am using Excel 2000 on a Win XP machine.
Is there a way to use a type of drop down menu, but be able to select more than one text value to populate into each cell?
I have a list of approximately 30 properties we used to describe documents and I would like to see each in the drop down menu or list, but be able to select one or more than one to associate with each document in the system (over 1000). Each document is associated with a set of these properties that is likely, but not necessarily, unique.
Is there a way this could be set up in excel, or is this a functionality that doesn't exist?
Thanks in advance!
Is there a way to use a type of drop down menu, but be able to select more than one text value to populate into each cell?
I have a list of approximately 30 properties we used to describe documents and I would like to see each in the drop down menu or list, but be able to select one or more than one to associate with each document in the system (over 1000). Each document is associated with a set of these properties that is likely, but not necessarily, unique.
Is there a way this could be set up in excel, or is this a functionality that doesn't exist?
Thanks in advance!