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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |