Fixed date stamping cell

[megan42]

I need to create a formula or Macro to assist with the following.
If cell M2 shows "Completed"
Then I want cell M2 to show the date this occurred.
I had an IF formula input into the cell but it would change the date every time the spreadsheet would open.
I am not very good with VBA coding so kind of need a copy and paste solution.

Thanks

[YasserKhalil]

In sheet module try this code

Please Login or Register  to view this content.

[megan42]

Thanks YasserKhalil,
How do I get the data to input into N2 cell?

[YasserKhalil]

Change the letter "M" in this line to "N"

Please Login or Register  to view this content.

[megan42]

Sorry I don't really understand how this will work?
If I want the Macro to read 'Completed' in column M and then output the date in column N how can this be done?
The coding in this thread doesn't seem to reference both cells?

[YasserKhalil]

Try this

Please Login or Register  to view this content.