sequential numbering for invoice

gerard craggs · Jul 21, 2005

HELLO

I HAVE A SMALL BUSINESS, AND I WOULD LIKE TO AUTOMATICALLY NUMBER MY
INVOICES EVERY TIME I REOPEN THE TEMPLATE. THE CELL REFERENCE IS M3.

I HAVE TRIED EVERY THING I KNOW, AND TRAWLED THE INTERNET, BUT CAN NOT FIND
AN ANSWER. SURELY THIS WOULD BE A SIMPLE THING TO DO.

YOUR HELP WOULD BE APPRECIATED.

REGARDS

GERRY.

Bob Phillips · Jul 21, 2005

Take a look at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

gerard craggs · Jul 21, 2005

THANKS FOR YOUR REPLY BOB
I TRIED THIS YESTERDAY BUT COULD NOT GET IT TO WORK, HOWEVER IF THERE IS NO
EASIER WAY I WILL KEEP ON TRYING.

REGARDS

GERRY

Bob Phillips said:
Take a look at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Bob Phillips · Jul 22, 2005

Gerry,

What problem did you encounter. It seems pretty straight-forward to me, and
almost bullet-proof.

--
HTH

Bob Phillips

gerard craggs said:
THANKS FOR YOUR REPLY BOB
I TRIED THIS YESTERDAY BUT COULD NOT GET IT TO WORK, HOWEVER IF THERE IS NO
EASIER WAY I WILL KEEP ON TRYING.

REGARDS

GERRY