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?

Hello,

If I am following, no need for VBA, see the following:

http://mrexcel.com/board2/viewtopic.php?t=53213

Thanks Nate

You are welcome.