Given that an invoice might list multiple items, it's not as simple as automatically assigning a new number for each item. For one possible approach, see:
https://www.msofficeforums.com/excel...g-invoice.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]