Next blank line
 

I would like to automate part of a new workbook, so that certain information
is extracted from one sheet and entered into another, and then inserted back
again. Here's what would happen:

1) User opens sheet
2) Sheet automatically selects a number from a list in a "storage sheet",
ADDS 1 to it (i.e. sees BP00001 in cell A1 in the list has been used, because
the cell B2 has been filled in), adds 1 to it to make BP00002 and then
inserts that number into A2
3) User fills out form, etc etc
4) User clicks button, their information is transferred to the next blank
line in the "storage sheet" (or possibly even to Access database, but that's
another issue)

I'm sure I did this before but I can't for the life of me remember how...!