• I'm a rookie to Excel, so bear with me please. I'm trying to create an invoice template in Excel 97. I want it so that whenever a person opens the invoice template, the invoice number adds 1 to the previous invoice number. Can anyone please help? :question: i'd be forever grateful!! :D

  • you could put some code in the Workbook_Open event:

    Private Sub Workbook_Open()
    Range("A1").value = Range("A1").value + 1
    End Sub

    To enter this, right-mouse click on the Excel icon next to the File menu and choose View Code

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!