Prev Previous Post   Next Post Next
  #1   Report Post  
Murphey's Law
 
Posts: n/a
Default invoice numbers

I have created an invoice/proposal template that I want to have the invoice
numbers to be generated automatically to reflect the first three or four
letters of the customers name (in caps), how many times I've done business
with this individual, the month,day, and year of when the invoice was
created, and how many pages in the proposal/invoice were created. An example
of "Mr. Jones" second time doing business with me, written on May 28th, 2005,
and having three parts to the proposal, would look like this: JON0205280503.
Any suggestions would be appreciated.
 
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
How do I assign sequential numbers in an invoice? halex New Users to Excel 4 May 5th 05 06:46 PM
Invoice Numbers Russ Excel Discussion (Misc queries) 1 January 29th 05 05:55 PM
Generating Invoice Numbers Sarah Excel Worksheet Functions 1 January 28th 05 06:51 PM
Invoice numbers? Missie Excel Worksheet Functions 1 December 13th 04 07:28 AM
how do you change invoice numbers automaticly wendy New Users to Excel 1 December 11th 04 12:42 AM


All times are GMT +1. The time now is 04:29 AM.

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

About Us

"It's about Microsoft Excel"