Auto populate invoice (including description) from data sheet

[agenevieve]

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!

[Kevin@Radstock]

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

[macropod]

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