I am trying to find a way to automatically add comments to specific cells. I want to be able to create a cell history. For example:
Say I have the number "5" entered in cell A2 and the word "vase" in cell B2. If I then enter the number "3" in cell A2 and the word "bowl" in cell B2 I want it to automatically add the original number "5" and word "vase" in a comments box for cell A2 that appears when you hover the cursor over the cell.
Is this at all possible? If so does anyone have a code suggestion?
Any help would be much appreciated.
Thanks
Bookmarks