I assume that some of you guys also track your investments in excel. I am right now trying to build a daily value tracker, but I can`t find a solution to make sure that I only have one date entry when I hit the button multiple times a day.
The Code so far:
ActiveSheet.Range(“A1”).End(xlDown).Offset(1, 0).Value = Date
ActiveSheet.Range(“B1”).End(xlDown).Offset(1, 0).PasteSpecial Paste:=xlPasteValues