Command Button Keeping Screen Position

Hi all,

I am using a command button to enable the user to skip down to the last row of data in column B. The reason is because the user will be loading this particular sheet with source data. So, he will paste in the first table, click the button and the next empty cell down column B will be selected and readied for the next table. Is there a way that the command button can stay on the view screen while going down the rows?

Kindest Regards,
Michael