Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto Number in Invoice
Grab this file, hope you have WinZip or something able to open .zip files,
and extract both files in it TO THE SAME FOLDER. The two files, one .txt and one .xls, must be in the same folder for some features to work. This will show how it can be done, and I've added lots of comments so hopefully you'll be able to customize it yourself. If not, ask questions here or via email and I'll try my best to answer. In previous book, I misinterpreted what you'd tried and thought there was a name of some type in E5, not that it was where the invoice number was to be placed. This fixes that. It's NOT 100% automatic - it is an on-demand function via macro that grabs a value from the .txt file, increments it by one and stuffs it into E5 and then also saves that number back to the .txt file so that the next time you use the macro, whether in that workbook or another, you'll get the next sequential invoice number. This is all based on McGimpsey's sample work. What I've done with it to modify it is to take away the need to define a default path to the .txt file, although you may do that also, and may want to. But if no default path is provided, then it gets the .xls file's path and uses that to go find the InvoiceNumber.txt file - and that's why both files need to be in the same folder. http://www.jlathamsite.com/uploads/for_PammiJ.zip if you get a security alert about a .zip file and aren't permitted to upload it, try right-clicking the link and using Save Target As. "Pammi J" wrote: Thats exactly what im after Lizard1socal - exactly what that template does with the invoice number - unfortunatly i cant get into it - its asking for a password "lizard1socal" wrote: JLatham, Appreciate the reply, although as a simple user didnt understand it all , but got the jest of what you wrote. My next question is that , in Excel there is a business invoice template that has the area for the invoice number, and shows a number in the template. Now if the template has and shows the number, isnt there someway to activate that cell with an auto number formula ? ( a new users question,basically ignorant here ) Thx for your help, undrstanding and patience with us of lessor knowledge ! LIZARD1SOCAL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to do a auto number generater | Excel Worksheet Functions | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Auto Number | Excel Discussion (Misc queries) | |||
Auto number invoices in Excel | Excel Worksheet Functions | |||
assign auto number and auto date | Excel Discussion (Misc queries) |