Looping dates continuously with user option of stopping

[dem tacos]

Hi all I am new to the world of vba and I need some advice

I have a spreadsheet with a column for dates, sales data, and buyer.

This is a spreadsheet in a share folder and so needs to update continuously over the course of the year.

What I am having a problem with is that I can’t really figure out how to loop the InputBox down the column so that when I revisit the spreadsheet in a month to enter the new sales data through InputBox I can just pick up where I left off from in the last cell.

I am also enough of a noob that I am having problems getting the formula to end by just hitting cancel and not getting an error message.
Any ideas are really appreciated. I would post what I have so far but it’s so awful I am really too embarrassed.

[dem tacos]

anything would help