Hi,



I am hoping to get help on creating an Excel invoice that would auto-populate from another Excel worksheet or file with data. The information that I would want to include are:
Company name
Name (person)
Email address

Start date
End date
Promotion description
Number sold
Price per item
Total charged

I don't have much experience in Excel, and would appreciate any advice or suggested templates! Thank you!

Hi agenevieve

INDEX & MATCH, VLOOKUP etc

Try here. Do a search for the functions that lookup.

Microsoft Office site has a selection of templates.

Kevin

Depending on your data layout, you might also find it fairly straightforward to produce the invoices via a mailmerge from Word. See: http://office.microsoft.com/en-us/ex...005209293.aspx

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]