I was "semi" successful in using Private Sub Workbook_Open routine...

Open a new workbook and name a sheet "Invoice"
Right click on that tab and click View Code.
Double click on ThisWorkbook in the VB Project tree and paste the code in
the large white space.
Now Save As and when the Save As prompt window comes up, click the down
arrow on the "Save as type:" and save as a Template... use a name of your
choice.

Now open that newly saved template and you should get the date in B1 and an
invoice number in B2.

Save this "new invoice" to a name of your choice and close it.

Open the Template again and you should get a new workbook with the date in
B1 and the next invoice from the last in B2.

Repeat for the next... etc.

I do not know how to reset the invoice number if necessary and it started
with 0004 for some reason.

HTH
Regards,
Howard

"ccmintern" wrote in message
...
I am working on an intercompany supplies transfer form and all I need to
complete it is a sequential (invoice) number.

I am not familiar with macro, but have tried to teach myself by reading
the
other posts, but it's just not working.

Figured I would just ask for help. Thank you in advance! I really
appreciate it.