View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nexor
 
Posts: n/a
Default sequential invoice numbering

Hi there,
I have designed my own invoice in exel, in the same workbook as the invoice
I have an invoicing sheet with a custom invoice no's. collum and a client
name collum, to keep record of invoice numbers that had been used. What I
need is to prevent duplicating invoice numbers by way of a formula that can
generate the next available invoice number.