last value in a column - How to find

[Princy557]

Hi,
From worksheet A, how do I find the last value used in colum B on worksheet C. I have looked but not found in help or manual.

I'm working on using an incrementing invoice number held in an worksheet.
A B C
1 Date Last Next
2 01/09/2019 0000 0001

So I would also need to add the date and insert both last and next.

Is this a basicmaker job? Anyone give me a hint please.

Regards
Princy557