Hello!


I have the attached file containing a table. In cell A1, I want to enter a text that can be deleted and re-entered (the text can be different, not the same). I would like the history of the text I enter in cell A1 of Sheet1 to be displayed in the Control sheet. I tried to create a formula following an internet tutorial, but unfortunately, it doesn't work, even though I set the iteration to the maximum (32767) and activated the option. I want to specify that Sheet1 could be renamed during work. The tutorial suggested to insert a hidden cell to display the expected result; I inserted it in cell A100, A101. What did I do wrong?Tks for the answer!

Attached Files

Table.xlsx (24.1 KB, 1 views)