| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 80010 | 2007-06-08 11:31:00 | Consecutive Numbering Excel Invoice | David57 (7859) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 557312 | 2007-06-09 05:47:00 | No David57 and winmacguy are not one and the same. | David57 (7859) | ||
| 557313 | 2007-06-09 06:02:00 | How come David57 asked the question yet its winmacguy handling all the replies? One and the same? I just happened to be interested in David57's question, possibly for the same reason. I am helping the guy I work for to set up his billing and invoice system in OpenOffice and he was asking me how to do template numbering. |
winmacguy (3367) | ||
| 557314 | 2007-06-09 06:30:00 | I am of the opinion that the consecutive invoice number should be able to be created the same way that the date can be and that is by way of a formula however i wonder if there is any excel whizzes out there that can help. David |
David57 (7859) | ||
| 557315 | 2007-06-09 06:39:00 | The consecutive number inremented each time it was opened would be a nightmare I suspect. It would (like the date field in Word) increment any time the sheet was subsequently opened as well, so your financial records would be incorrect as to invoice number. To circumvent that would require something clever enough to recognise that the sheet was initially opened, and after that event the figure would have to be changed to a normal constant in any subsequent opening. It sounds quite horrible. |
godfather (25) | ||
| 557316 | 2007-06-09 09:01:00 | Write a macro that combines the date and customer code ie 020107BMA striping the formating from date (2/1/07 beama), yes a little vba would be needed . Andrew or Parry should be able to help do this they are the gurus in this area. Google, also, should reveal some code snippets to do this. It may be possible to use the formula functions within excel to do this such as left(), right() , now() and concatenate() functions but I'd have to play with it, if I get time. |
beama (111) | ||
| 557317 | 2007-06-09 09:23:00 | not quite want you specified but may do the job in the cell you want the invoice number =CONCATENATE(LEFT(TODAY(),6),B1) B1 holds the customer code didn't take that long after all :cool: |
beama (111) | ||
| 557318 | 2007-06-09 10:53:00 | not quite want you specified but may do the job in the cell you want the invoice number =CONCATENATE(LEFT(TODAY(),6),B1) B1 holds the customer code didn't take that long after all :cool: That looks very interesting, I'll have to try it and see what happens :) :thumbs: |
winmacguy (3367) | ||
| 557319 | 2007-06-09 11:45:00 | just knew google would have the answer www.mrexcel.com |
beama (111) | ||
| 557320 | 2007-06-09 23:18:00 | Hmmm, I use a program called Invoice2Go... I got it off an old APC Mag... It is a free full version, If you're interested I'll upload it to Rapidshare or something like that with the registration link for you. It's a great program and I use it all the time for my clients. PM me if you want to give it a whirl. Cheers |
chiefnz (545) | ||
| 557321 | 2007-06-09 23:29:00 | on a side note... I used to invoice in excel but changed to cashbook complete. I find it great for tracking invoices, something that you can't do easily in excel. | Clark (11819) | ||
| 1 2 3 | |||||