Hi!

I am hoping there is an easier way to do what I'm looking for:

Column N in my sheet contains notes. What I am looking to do is have only my most recent note in column N and put the older notes into column P just to have for a record. So when I update N I would like to know if there is a way to easily copy what is currently in that column into P. The problem is, if I just copy paste quick it overwrites what is previously noted in P.

Maybe this example can help:

CURRENT INFO:
N------------------P

arrive 3/15---------arrive 3/10


WANT TO UPDATE TO:
N------------------P

arrive 3/19---------arrive 3/10, arrive 3/15



I am using this sheet to keep a record of contact with manufacturing vendors and need to record when they say our items will arrive and if that date changes I need to keep record of what it was originally for reference....

Gosh it seems much more complicated on here then in my head!!

Let me know if some more info can help at all...

Thanks!
Ashley