I have an excel sheet which is constantly updated by Bloomberg automatically. I need to create a log of any change in value in a particular cell to a different range within this sheet/workbook. Any new entry to the log should always be exactly below the previous entry.
For Example :
Value of A1 is changed to 10 -
An entry will be made in cell C1 as '10'
Again the value of A1 is changed to 20 -
An entry will be made in cell C2 as '20'
And so on....