Button to find last record

put a command button on sheet from the control tool box
(if you cant see it right click tool bar and check control tool box option)
right click it
view code
put this in

Private Sub CommandButton1_Click()
'LastCellInColumn

Range("A65536").End(xlUp).Select

End Sub

click file and exit to excel
rigt click button again
click comand button object
edit name of button
then on control tool box tool bar click the triangle thingy on the left side to exit design mode
now cllicking button will go to last used row in col A