Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Updating a cell value when other cell value change....

  Asked By: Mona    Date: Sep 08    Category: MS Office    Views: 922
  

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 the
information about the price of one article in the columns "E" I have the
date of that price.

Is it possible to make a macro that update the date in the columns "E" each
time that I change the price?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Frances Parker     Answered On: Sep 08

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) = Date
End Sub

 
Didn't find what you were looking for? Find more on Updating a cell value when other cell value change.... Or get search suggestion and latest updates.




Tagged: