Find first empty blank row and go to it

Hello.
I have an Excel googledocument that looks like this.

s-R3PN2VTfimOe1TD1xH2A.png

The list is very long, and ends at column 210.

I5lG2EMLRfWdeDa1IFVOVw.png

Continually, new row entries are being added.

I want to create a macro at the top of the document that will, when clicked, send the user to the bottom of the page (where the last filled row entry is)

Or return the last filled row entry.

Please help!

Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

In addition, please avoid posting pictures, rarely are they much use. Upload the workbook.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Something like this.

Please Login or Register  to view this content.

Hi,

You appear to be using Google Sheets, not Excel. I'm not familiar with the Google Script language but I doubt it's entirely consistent with Excel VBA macros. Your request would be better on the 'Other Platforms' sub forum.

Please confirm if it is indeed Google Sheets you're asking about and I'll move it for you.

This might help.
https://stackoverflow.com/questions/...-google-sheets