Excel query

  starlet 07:16 29 Jun 2005
Locked

Can anyone explain to me how to put into a spreadsheet an invoice number that automatically advances by one each time you create a new invoice.

Regards Starlet

  VoG II 07:41 29 Jun 2005

Press ALT+F11 to enter the Visual Basic Editor. Insert | Module. Enter the following code which assumes that you want the invoice number in cell A1.

Sub Auto_Open

Range("A1").Value = Range("A1").Value + 1

End Sub

Exit the VBE. Each time you open the saved workbook the number will increase by 1.

  starlet 08:02 29 Jun 2005

Thanks VOG,
you have come good again what would we do without you.
Regards Starlet

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?