Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
gerard craggs
 
Posts: n/a
Default 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



  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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





  #3   Report Post  
gerard craggs
 
Posts: n/a
Default

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







  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequential numbering REELAXER Excel Worksheet Functions 1 June 30th 05 12:25 AM
sequential numbering of zero leading values nagorb Excel Discussion (Misc queries) 1 June 8th 05 04:58 AM
sequential numbering in non adjacent cells Sue Excel Worksheet Functions 6 June 4th 05 03:16 AM
automatic sequential numbering in excel or word greg2 Excel Discussion (Misc queries) 1 January 15th 05 05:35 PM
How do I set up sequential numbering on labels inventorybrokers Excel Worksheet Functions 3 November 19th 04 04:46 PM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"