Copying a Changing Cell Content in One Sheet into a Column in a Different Sheet

[ainon123]

I have an Update Sheet where every week i update the content or value in a particular cell. I need the content to be then copied into a column in a History Sheet. That is, each row in the column in the History Sheet will display a week's updated value. So if i update the cell value 100 times in the Update sheet, i will have 100 rows of values automatically generated in the column in the History Sheet without me even needing to open the History Sheet

Please help.

 

[L. Howard]

Does the sample test workbook from downloading the link work for you?

Howard