How can I make the following (if it is possible)?I have a file that have about 2000 rows. In the columns "D" I have theinformation about the price of one article in the columns "E" I have thedate of that price.Is it possible to make a macro that update the date in the columns "E" eachtime that I change the price?
Put something along these lines into the worksheet code:Private Sub Worksheet_Change(ByVal Target As Range)If Union(Range("D2:D2000"), Target).Address = "$D$2:$D$2000" Then _Target.Offset(0, 1) = DateEnd Sub