You could use Data Validation and Vlookup formulas to create an invoice.
There's an example he

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Invoice for Selected Number'

creating many invoices from excel data wrote:
I need help with creating invoices (excel file) that have my individual
customers information from another excel file. To be more clear, I have a
standard invoice (excel file) with name, address, and balance missing. I
need to incorporate information from another excel file that have names in A,
address in B, and balance in C. I need it to print out many invoices with
each one containing one costumer info. Please help me.. Thank you


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html