I have created a simple invoice system using a template invoice. You know, the templates that come with office 2010. In this 3 part video series I create a form based customer management section that works with the invoice part. And with various controls I am able to import customer data into the Invoice. I would put the code on the page.
Download from here:
Excel VBA Invoice System Part 1 – Video
Excel VBA Invoice System Part 2 – Video
In the 2nd installment I refine the customer management system with the added convenience of being able to update customer data and move the customer address to the ship to section of the invoice.