Numbers opens file at the 1st row and not where left editing
I have been keeping daily records of certain information since 2002. At first I used to keep the spreadsheet in Excel but recently moved to Numbers. Sometimes I open the file, either on my MacBook Air or iPad Air the file opens at the first row and not at the last entry point. It is not a major issue on the MacBook but on the iPad it takes hundreds of swipes to get to the latest date and many minutes to do that. I know I can search for the latest date but I would like to know how I can open the file and know it will go to the latest date, which it used to do.
MacBook Air, iOS 8.3