|Well, I'm confused. Keep in mind that we can not see your worksheet from where we are sitting.|
re: "I have about 20 values in a drop down list according to each person, but a person can have more than one of those categories over a month's span."
What do you mean by "according to each person"? Do you mean that you have a column of names and a drop-down list next to each name?
re: "I have those same values spread across right next to it, 20 columns. "
By "it" I assume you mean the drop down list, correct?
re: "Each of those has a box to tally each category when chosen."
I have no idea what that means.
re: "I want to pick a value from the list, have it recorded, then be able to choose another one but keeping the past selections. "
Have it recorded where? Keep the past selection where?
I don't see the relationship between your "20 columns of values", the drop-downs, the tally, etc.
Perhaps some example data would help. Please click on the following line and read the instructions on how to post example data in this forum.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.