VBA - Insert timestamp if cell to left = x

I would like to be enter the date when "x" is entered into the cell to the left of the target cell. I want to limit this to cell B2:K20. If x is entered into B3, then the date populates in C3. This will show the date a task was completed.

Right click the sheet tab and select "View Code". Copy the code below and paste it into the VBA screen.

Please Login or Register  to view this content.

Is that what you mean?

BSB

Thanks so much for the fast reply. That works pefectly.

Happy to help

BSB