"TheExpat Wanderer" wrote in message
thank you again.
ill make my question very easy. and it will do what I want


Firstly , Cell B1 will take the value from A1
then if A1 value changed , it's value will be in Cell B2.(B1 will not
change)
if A1 changed again ,it's value will be in Cell B3.(B1,B2 will not change)
if A1 changed Again ,it's value will be in Cell B4.(B1,B2,B3 will not
change)

and so on

thank you in advance.

I'm sorry but I cannot relate any of the above to your screenshots. Did you
try the original macro and then did you try what I suggested last time?

If anybody else with a different set of eyes can follow please jump in :)

Regards,
Peter T