Excel: Cells Update automatically from last entryLocked
I have a large spread sheet with two tables, one table is for “summary” and the second table is for “data entry”. I want one of the cells (in the summary table) to be able to read the last value entered in the “data entry table”. For example: Cell I8 currently display the same entry as U37 (using the simple equation of =U37) when I input an entry to U38, I want I8 to automatically take it rather than me having to go back and change the equation of I8 cell to “=U38”
Any suggestions to how to code I8 cell to do that?