![]() How do i get word to insert a new bookmark (or something) based on the number of products a person has sold.Īttaching a sample document showing the invoice form would really be helpful. You can create professional looking invoices with a template that you can customize for your business. Some publishers may have sold 5-10 different products, while some may have only sold 1 or 2. Download a free Invoice Register template for Microsoft Excel, which helps to create a log and keep up with all of your organizations invoices and. Schedule appointments Track leads, sales, data Work with employees Create estimates and invoices When you’re a small business that provides a service to customers, then you need to be able to bill them for those services with an invoice. However, in this particular invoice form, I have to create a seperate listing in the description field for each product a publisher sold (including how many they sold and how much money they are owed). Issue 2: Bookmarks seem like a nice way to use VBA to replace their values with excel data (in theory, i've only read about it and never attemped). Any Ideas on how to automate that, as we have 100's of publishers and invoices are done every month. I could create a seperate database in excel with each publishers address and name but then it might get difficult to match these up. Would it be possible to create an initial template for each publisher and then have the rest of the information be populated with the data from the CSV that has their sale information. ![]() The problem is, the information i'm pulling the number of sales (and money we owe them) is from a different spreadsheet every month and wouldn't contain this address information on it as it is an aggregate spreadsheet of ALL publishers numbers. Issue 1: Each Invoice form has the publishers Name and Address listed at the top of the form. I'm not sure how to attach the sample invoice, so i'll do my best to write them out and if i figure out how to attach a doc by the end of this i will include a sample so you see what I'm talking about. I'm having a couple of issues logistically though. Then I would use VBA to populate those bookmarks based on the person (publisher in this case) i was invoicing. The way that I was thinking about doing this would be by creating a template in word and using bookmarks. Essentially, I need to take a bunch of information that I have in excel and populate a Word Document to create an invoice. I've tried searching this form (and google) and I haven't quite found what I'm looking for so i figured I would ask a question.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |