Hello,

I have a problem and I am pretty sure this has been solved already but after hours of using google I am still not able to solve it...

The story is the follow:
The table I have contains various columns with lots of entries. What I need now is a kind of history in another column (B2)...
- If I make a change in A1 then the old content of A1 should be moved to cell B1.
- If another change is made to A1 then the content in B2 should be overwritten with the new (old) content of cell A1
- If I change the content of A2 - B2 automatically should overtake the old value of A2.
- and so on and so on - all in the same sheet (no log-files or so - also I don't need to know the date or time or whatever, just a content replacement)

I create a form of database for our in-house equipment database and would like to have a small user-history (of who used the equipment the last two times).

Please Help! I assume there is already such a thread but it seems I am too stupid to look for the right words. I am an absolute beginner to VBA, which means I need full codes or very (VERY) detailed descriptions.
Btw. I am using MS Excel 2011

Thanks a lot guys!
Mathias