I am looking for simple code. I tried myself but can't seem to get it to work.
In the A column, user will be entering values. In the B column, I have a formula that will enter the system time ("now") only when a value is entered in A.
I need macro code so that once a value is entered in column A, the values from column B are pasted special (as values) into column C.
I think I need to use Worksheet_change and the following code line.
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Also, there is no way to do this simply with a formula and without macros is there?