Change date in a cell if I change any cell within its row

[LewisM]

Hi, guys, please help.

This is what I got:

	A	B	C
1	Blue	Cherry	01/05/2014
2	Orange	Cherry	01/05/2014
3	Purple	Cherry	01/03/2014
4	Yellow	Cherry	01/06/2014
5	Red	Apple	01/02/2014

If I change any value in column A or B, I want that its respective date in column C changes to today's date.

E.g., I will change B1's value. If I do it today, C1 must change to today's date (01/30/2014).

	A	B	C
1	Blue	Banana	01/30/2014
2	Orange	Cherry	01/05/2014
3	Purple	Cherry	01/03/2014
4	Yellow	Cherry	01/06/2014
5	Red	Apple	01/02/2014

It must keep this way until any change is made again in A1 or B1.

Column C is something like 'Last update'.

Any idea on how do I do this?
Thank you so much.

[HaHoBe]

Hi, LewisM,

I´d prefer VBA for this, right click on the worksheet tab, choose Voiew Code and paste in the code:

Please Login or Register  to view this content.

Ciao,
Holger

[Olly]

Right click your worksheet tab, and click 'View Code'

In the worksheet module that appears, paste the following code:

Please Login or Register  to view this content.

Done

[LewisM]

Thank you so much guys, works great!!!