Hyperlink to blank available row?

This should be relatively straight forward...

"A12" says "Click for new line". I want that to be a hyperlink so if someone clicks it, it will automatically take you to a fresh new line to input there information.

Row 14 and above is a frozen pane.

Anything from row 15 below will contain data.

I could have 1,232 rows and the users who are using this spreadsheet probably won't fancy scrolling down for ages to find a new row to enter the information...


Anyone help with this

Originally Posted by martindwilson

try
=HYPERLINK("#"&ADDRESS(COUNTA($A$15:$A$10000)+15,1),"click for new line")

Bingo - Spot on. That has worked PERFECTLY! Love this site!