Excel query

  starlet 07:16 29 Jun 2005

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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?