|If I'm understanding you correctly, in your invoice number |
column you want the following formula
=IF(B1>"",get the value from cell above + 1,"")
THis will automatically increment the invoice number as a new
one is entered.
Otherwise you might want to work with Access
What happened to my quote