SETUP AUTO SEQUENCE

G

Guest

What is the simplest way to set up sequential invoice numbers in a workbook?
I have 35 Invoices. Instead of typing the Invoice number on every
invoice/sheet, can I automate the invoice numbers to start at #1310 and
increase by 1 for each invoice/sheet? (The Invoice number must be on each
sheet)
 
D

Dave O

One possibility:
Start sheet one with invoice 1310 in cell A1 (or whatever). On the
next sheet, refer to that cell A1 and add 1 with a formula such as
=Sheet1!A1+1 and continue for remaining sheets.
 
G

Guest

It isn't working...can you explain step by step (just do 2nd sheet. I can
figure out how to apply to the rest.
 
G

Gord Dibben

Steve

A macro will do?

Sub Number_Increment()
Dim myNum As Long
Dim iCtr As Long
myNum = 1310
For iCtr = 1 To Worksheets.Count
With Worksheets(iCtr).Range("A1")
.Value = myNum - 1 + iCtr
End With
Next iCtr
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

template creates invoice - how to create summary worksheet? 13
Data Validation to exclude blank cells 6
Sum multiple invoice number 6
Lookup? 2
Cumulatively list data from each new worksheet 1
Auto Change Formulas - Please Help. 2
Invoice numbering 1
From Scratch - Tracking Payables 1

Top