HI Jlo33,


If you don't want previous information to be changed, then you should go for macros (vba) instead of requesting for formula as your title suggests.


Regards,
DILIPandey
<click on below * if this helps>