| 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 | ||
| 557302 | 2007-06-08 11:31:00 | I have created an invoice in excel and want to provide a consecutive number each time i open the invoice. Can anyone tell me how i can achieve this. If it requires VBA then i am not familiar with this and would appreciate any reply to be in depth if possible. Thanks in advance. |
David57 (7859) | ||
| 557303 | 2007-06-09 03:30:00 | You could type it in each time. Not hard. |
pctek (84) | ||
| 557304 | 2007-06-09 03:37:00 | You could type it in each time. Not hard. Not hard but not always accurate if your doing a lot of docs or invoices at different times on different days and multiple clients. The only reason I say that is because I am in a similar situation and would be interested in knowing what formula to use. |
winmacguy (3367) | ||
| 557305 | 2007-06-09 04:06:00 | Would autofill (computing.fandm.edu/training/excelx/autofill.php) do what you want? | Graham L (2) | ||
| 557306 | 2007-06-09 04:15:00 | Thanks for the suggestion Graham, but I use that already for columns. I that the solution is more likely a formula in the cell that is able to generate a new invoice number from a templated doc every time a new invoice is generated without having to remember what the previous invoice number was. eg: Client A Inv No.00003 Client B Inv No.00004 Assortd clients Nos. 00005-12 Client C Inv No. 00013 etc. all generated from Invoice template doc 00000. |
winmacguy (3367) | ||
| 557307 | 2007-06-09 04:27:00 | I'd imagine that this is a common requirement. Perhaps you're supposed to use a commercial accounting package which includes such features. ;) I'd suspect that a spreadsheet is not the most appropriate software for accounting and billing. A database would probably be able to handle the "client #, invoice #" easily in its reporting module; Word would do it. But they're not accounting software either. But someone will have made something to twist Excel's knobs to do it. It will just be a matter of finding the right keyewoprds for Google. :D |
Graham L (2) | ||
| 557308 | 2007-06-09 04:40:00 | Your probably right there Graham, but thanks anyhow. :) Looks like a google search might be the answer. | winmacguy (3367) | ||
| 557309 | 2007-06-09 04:44:00 | How come David57 asked the question yet its winmacguy handling all the replies? One and the same? | beeswax34 (63) | ||
| 557310 | 2007-06-09 04:51:00 | perhaps this www.google.co.nz | Graham L (2) | ||
| 557311 | 2007-06-09 05:42:00 | Perhaps you're supposed to use a commercial accounting package which includes such features. ;) Yep, too many cheap people think excel if the answer for all their financial needs. |
wotz (335) | ||
| 1 2 3 | |||||