VBA for copying and adding new cell value in every row

[FLAWLESSKING]

Hello Guys, i need to execute this simple thing...pls read below


A1 = 15


here a1 has cell value 15, so when I change it to 16, A2 should show number 15, when i change it to 17, A3 should show number 16,


means whenever i update the Cell Value A1, the new row records the previous value and posts the data one after another, something like this...


A1 = 15 (the number gets updated, and the previous number gets added below)
A2 = 15
A3 = 16
A4 = 17
A5 = 18

any help would be deeply appreciated, thanks a million.

 

[FLAWLESSKING]

sir, one problem here, my bad actually sir should have mentioned earlier, the data in A1 cell is web driven, the value updates after every 1 min when the page auto refreshes. its working if entered manually but not working in the web case, please sir if you could help me

 

[My Aswer Is This]

These type events only happen when manual changes are made to cells.

What your asking for is:

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.