ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sequential numbering for invoice (https://www.excelbanter.com/excel-worksheet-functions/36410-sequential-numbering-invoice.html)

gerard craggs

sequential numbering for invoice
 
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.



--


-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com




Bob Phillips

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

--
HTH

Bob Phillips

"gerard craggs" wrote in message
k...
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.



--


-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com






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
"Bob Phillips" wrote in message
...
Take a look at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
HTH

Bob Phillips

"gerard craggs" wrote in message
k...
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.



--


-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com








Bob Phillips

Gerry,

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

--
HTH

Bob Phillips

"gerard craggs" wrote in message
. uk...
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" wrote in message
...
Take a look at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
HTH

Bob Phillips

"gerard craggs" wrote in message
k...
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.



--



-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com











All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com