sequential numbering for invoice

[gerard craggs]

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]

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

 

[gerard craggs]

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

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

 

[Bob Phillips]

Gerry,

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

--
HTH

Bob Phillips

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