I have a 53-row 16-column spreadsheet. As each week of the year goes by another row gets filled with data from 16 individuals.

I want the bottom row to always represent a person's current score (since we're in week 9 of the year, cell A53 currently has the formula =A9).

However, when week 10 comes and the tenth row gets filled around I will have to change the formula to =A10. I would like to find a way to automatically select the bottom filled row rather than having to change the formula every week.

I have seen the related question Automatically select last row in a set in Excel but that solution did not work for me.