| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 51609 | 2004-11-25 09:03:00 | Excel Invoice | Ron Bakker (356) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 296245 | 2004-12-01 07:06:00 | Sorry about the delayed response. Really what I want to do( if you want the big picture) A: have a database of all the customers & what they bought. B:notes about the customer to give a profile. C: invoice customers online,but also have my own records on paper & PC D: purchase history of customers. Guess I should use Access 2000 Maybe Outlook 2000 would be good for the customer history thing as I am an online store. Thanks for your help guys. |
Ron Bakker (356) | ||
| 296246 | 2005-02-27 11:01:00 | hi parry or any one else i have a problem while making an invoice in Microsoft excel i have a product sheet and i want to be able to click on the product row and it appears on the invoice, i was thinking of macros (copy from the products sheet and to the invoice sheet) but what if the user wants to have more products in the future can you please help >? With the formulas and I want to also know how to generate automatic invoice number (I mean it generates a new number every time you open the invoice template?) thank you, waiting for a reply |
rafiaabdu (6451) | ||
| 296247 | 2005-02-27 21:30:00 | Easy peezy use cashbook form Acclaim software its bases on Access. I have just under 2000 items on inventory and it runs sweet. site www.acclaim.co.nz or something like it. tedheath |
tedheath (537) | ||
| 296248 | 2005-02-28 00:44:00 | hi parry or any one else i have a problem while making an invoice in Microsoft excel i have a product sheet and i want to be able to click on the product row and it appears on the invoice, i was thinking of macros (copy from the products sheet and to the invoice sheet) but what if the user wants to have more products in the future can you please help >? With the formulas and I want to also know how to generate automatic invoice number (I mean it generates a new number every time you open the invoice template?) thank you, waiting for a reply Welcome to the board. Yes those sort of things can be easily done but do you have your list of products in a different sheet than your invoice? If so that would mean selecting the product sheet then clicking on the various products then returning to the invoice. It may be better to have a drop down box on the invoice for each row where you enter a product. This could be done with Data Validation and requires no code. You may need a button on the invoice sheet (which does require code) so you can click it and store the sales details in your sales sheet. Let me know if thats what your after. regards Graham |
Parry (5696) | ||
| 1 2 | |||||