We have a group that has Data Validation dropdown list for each cell in Range N2:N100. What they need is that when they select an item from the list in a cell from that range to add the selection to the the corresponding cell in Column O and continue to append changes to build up a "History Trail"
Example User in cell N55 selects Delete Item. Delete Item shows up in O55. Next time user in cell N55 selects Replaced Text. Now O55 should appear as Delete Item, Replaced Text
And so on.
How can this be done with code in the Worksheet OnChange Event?