In excel I need an offset function the will let the cursor default to the next empty vertical cell?

Question

The data range range grows with additional rows with every data update.

Answer 1

To find the next empty cell in a column A, using VBA, the macro line would be:

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

Offset(1,0).Select

Change the column letter in the range reference to whatever column you want to set focus to.

Note: due to the sloppy way YA truncates formulas, I had to split this into two lines to show the entire code line.  This will work, as is, if you copy both lines and paste into a macro.  Or, you can rewrite it to one complete line.