(Solved) – How do I log the value of a excel cell with a timestamp together?


I’m new to excel and also to vbs / vba. I’ve researched this question alot on the internet before, but the only code I keep finding is only logging timestamp when any cells, cell value is changed.

I do indeed need the timestamp when the cell value is changed in addition, but mainly I also want to log the cell value itsself if it’s changed.

So I’m looking for a code that would work like the following

In the entire Column D, Row 1 – 43 you have alot of values that get updated from a web json api source they’re all raw numbers and get updated every minute…

I would want it to for example in Column K to print all old Cell Values and the Timestamp when they were changed into Column L.

Thank you in advance!

Leave a Reply

Your email address will not be published. Required fields are marked *