Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need step by step to add invoice numbering to excel template
I created a template in excel, now i need to create invoice numbering
starting with AM8023. I am new to 2007, please give me step by step procedures, Please. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need step by step to add invoice numbering to excel template
Start with this site - McGimpsey probably has the best explanation of how to
get it done around. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html You could put AM in a cell, right aligned, and the number returned using his method in the cell next to it, left aligned, and it would look like AM8023. "rmt" wrote: I created a template in excel, now i need to create invoice numbering starting with AM8023. I am new to 2007, please give me step by step procedures, Please. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need step by step to add invoice numbering to excel template
I dont understand how to put the codes in the vba, please can i email you the
template and you can do it for me, or give me the example of how the code should be placed. my next invoice number is AM8023. PLEASE. "JLatham" wrote: Start with this site - McGimpsey probably has the best explanation of how to get it done around. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html You could put AM in a cell, right aligned, and the number returned using his method in the cell next to it, left aligned, and it would look like AM8023. "rmt" wrote: I created a template in excel, now i need to create invoice numbering starting with AM8023. I am new to 2007, please give me step by step procedures, Please. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need step by step to add invoice numbering to excel template
Send the file to (remove all spaces)
Help From @ JLathamSite.com I'll set it up for you and send it back along with instructions on how I did it. It may take a day or so to get it back to you, I'm kind of loaded up for at least the next 24-36 hours with priority projects. "rmt" wrote: I dont understand how to put the codes in the vba, please can i email you the template and you can do it for me, or give me the example of how the code should be placed. my next invoice number is AM8023. PLEASE. "JLatham" wrote: Start with this site - McGimpsey probably has the best explanation of how to get it done around. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html You could put AM in a cell, right aligned, and the number returned using his method in the cell next to it, left aligned, and it would look like AM8023. "rmt" wrote: I created a template in excel, now i need to create invoice numbering starting with AM8023. I am new to 2007, please give me step by step procedures, Please. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need step by step to add invoice numbering to excel template
By now you should have received my response to your email. I provided 2
solutions: one that works by double-clicking on the cell that the invoice number is to be displayed in, and a second one that uses a .txt file to 'remember' the last invoice number used. If you have any questions about either, let me know via email since others can't see the solutions here. "rmt" wrote: I dont understand how to put the codes in the vba, please can i email you the template and you can do it for me, or give me the example of how the code should be placed. my next invoice number is AM8023. PLEASE. "JLatham" wrote: Start with this site - McGimpsey probably has the best explanation of how to get it done around. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html You could put AM in a cell, right aligned, and the number returned using his method in the cell next to it, left aligned, and it would look like AM8023. "rmt" wrote: I created a template in excel, now i need to create invoice numbering starting with AM8023. I am new to 2007, please give me step by step procedures, Please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Step By Step. What URL to use in Lesson 8? | New Users to Excel | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
can't install CD from Excel 2003 step by step | New Users to Excel | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |