Previous Topic Next Topic

The DATE that i enter the DATA

Closed
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 - 18 Jan 2015 à 00:56
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 19 Feb 2015 à 12:52
Hello,
is that possible to know the date that i enter the data in a cell.
for example i enter the data in cell B1 today and i want this date in C1 cell
(i dont wanna use track changes option)
thank you for your answers
Related:

3 responses

Réponse 1 / 3
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 1
20 Jan 2015 à 23:20
guys i need your helps
i will appreciate your answers
thanks.
Réponse 2 / 3
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 1
18 Feb 2015 à 07:13
im still waiting.
i really need to know is there any answer for this,
thanks for your replays.
Réponse 3 / 3
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
19 Feb 2015 à 12:52
I found this after a very quick Google:

https://stackoverflow.com/questions/9311973/automatic-date-update-in-a-cell-when-another-cells-value-changes-as-calculated

Following the instructions in there.
I've tried it and it works.

It uses the Workbook Custom Properties to store and compare any changes.