Cell Changes (A:A) will automatically add in column as historical data

[aliffrusli]

Hi expertise,
I need help on current VBA I'm working on right now.
Whenever I input in any of cell in "A:A" it will automatically register in B column.
If I overwrite value in A column for 2nd time, the new input data will be captured in B column and old data move to column C
As example I input 26/3/2023 in cell A2, B2 will be automatically captured 206/3/2023 as output.
And after that if I input new data 30/5/2023 in A2, B2 will reflect 30/5/2023 and C2 will reflect previous value as 26/3/2023.
The same logic applicable to any cell in A:A will inherit the same row column. Can anyone please help me? I already meet dead road. Thank you.

 

[aliffrusli]

Guys..
Thank you so much for your help. Seriously through this forum i can learn alot new things. Have a nice day ahead ya!!!

 

[aliffrusli]

Hi guys..would like to ask if I want count how many date has been stamped is it possible?

 

[HaHoBe]

Hi aliffrusli,

please do not ask the same question in different threads (Excel VBA: How to count cell and whenever cell change will keep the old and new data continuously).

Holger

 

[aliffrusli]

Im so sorry Holger. My fault on that.