How to use automatic number for invoicing | Excel forum

Hi Valerie

For your invoice number to update automatically you will probably need a macro which runs whenever the file is opened.

Here's the macro for an example where the invoice number is in E3.


I've atached the file so you can test it out and find the macro.
Prees Alt+F11 then double click on ThisWorbook to se the macro code:
Private Sub Workbook_Open()
Range("E3").Value = Range("E3").Value + 1
Range("B14:E29").Clearcontents
Range("E2").value = date
End Sub

The macro increases the invoice number in cell E3 by 1 and clears the range B14:E29 then adds today's date into cell E2.
You can have other cells cleared like the address as well.

Finally the invoice file has to be saved as a macro enabled workbook with a .xlsm extension.

Hope that helps and gives you some ideas for now.

Regards
Doug Dunn
Best STL