Excel query

  starlet 07:16 29 Jun 05
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 05

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 05

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced