If you know just now where the last cell with data is, start recording and place your cursor in the same column at the top and hit control and down arrow to get to the bottom of the data set then do the same again to get to the bottom of the page. Now use control and UP arrow, which will make your selection jump back into the last cell with data in it, switch to the relative button and move to one cell below then stop recording. as long as your data stays in the same column, then running that macro will always bring you to the cell one below the last one with data in. I'm sure the same trick will work with the last rows but some of the more experienced macro users will know.
be sure to have the same cell as your starting point when running the macro