Next number function
 

I have an invoice book of 100 invoices. I need something that will
show me the next number to use for the invoice number. The invoice
number series (say 10001 - 10100) is set manually on the covering
worksheet, but i need something to add the correct number to the
invoice, being the next number in the series. Of course I can create
a range of numbers to use, but how will one formula in the invoice
number cell be used to allow for the next number?

Esra
TIA

Next number function
 

Look he

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

(Site currently down! 15th July 08:30 UK time)

"excel" wrote:

I have an invoice book of 100 invoices. I need something that will
show me the next number to use for the invoice number. The invoice
number series (say 10001 - 10100) is set manually on the covering
worksheet, but i need something to add the correct number to the
invoice, being the next number in the series. Of course I can create
a range of numbers to use, but how will one formula in the invoice
number cell be used to allow for the next number?

Esra
TIA

Next number function
 

Hi Toppers,

I was going to respond last night/this morning and give the same
reference but found the site was down then. Other posters have
commented on it being down as well.

Pete

On Jul 15, 8:28 am, Toppers wrote:
Look he

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

(Site currently down! 15th July 08:30 UK time)



"excel" wrote:
I have an invoice book of 100 invoices. I need something that will
show me the next number to use for the invoice number. The invoice
number series (say 10001 - 10100) is set manually on the covering
worksheet, but i need something to add the correct number to the
invoice, being the next number in the series. Of course I can create
a range of numbers to use, but how will one formula in the invoice
number cell be used to allow for the next number?

Esra
TIA- Hide quoted text -

- Show quoted text -