DH Templates

Possible for Excel to automatic inserts a new number...?

I've just designed an invoice template for my dad's company, and I've got it so every time the excel template gets opened it inserts today's date and all the calculations with VAT, unit price and quantity has been sorted (also with an if statement to leave the cell blank if no quantity has been entered). My question is - is it possible to get excel to insert a number into the Invoice Number box? The plan is to have the invoice number looking something like xxxx111111 so every time they make a new invoice the number would change from xxxx111111 to xxxx111112 then xxxx111113 and so on. Also would it be possible to have it save the new invoice as the new invoice number?

Public Comments

1. There is a video tutorial in the Excel help file for this very thing. Enter this in the search box of Excel help: Generate invoice numbers in Excel The first item listed should be the tutorial.