View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 2
Default Macro to increment invoice number

Hi all,

I have a template that I use for invoices and would like to know how I can
get the invoice number to increment by one everytime I create a new invoice,
I know I have to enter the code into an autoexec macro but what would the
code be to check the last invoice used and then increment this one by 1.

Thanks in advance for any assistance

Paul