Our HR dept uses an Excel based Performance Review sheet. I currently have the sheet set up with a comments section under each key point. The comments are set up to a Data Validation, allow list, in-cell Dropdown, and it pulls the list from the 2nd tab on the worksheet.

The users are running into an issue if they try to edit a comment that they selected from the list. For example, one of the comments reads: "Manages his/her time well". The user is trying to remove the "/her" so it now reads "Manages his time well." Whenever the change is made and you click out of the box, it duplicates the entry. So the first time it will read "Manages his/her time well. Manages his time well." Then the user try's to remove the 1st "Manages his/her time well." and clicks out of the cell it now reads "Manages his/her time well. Manages his time well. Manages his time well." the next time it will triplicate it "Manages his/her time well. Manages his time well. Manages his time well. Manages his time well." etc etc.

Is there anyway to eliminate this duplication from happening? Should I be setting this up a different way instead of data validation?

My interim solution was to remove the "his/her" wording thereby eliminating the need to adjust. But this doesn't apply to all the comments they change.

Thanks in advance for your assistance.