Auto populate invoice (including description) from data sheet

[agenevieve]

Hi there,

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!

[TBG]

I would recommend turning both the sheet you want to copy from and the destination sheet into tables. Give the 2nd sheet only the column headers you are looking for, and tell them to look @[appropriate column header] of the source table. Then you just have to make sure the 2nd table has the same number of rows as the first, and your done. Easy to expand both tables as you add more data as well.

Here's a good place to start for the basics on tables: http://office.microsoft.com/en-us/ex...010048546.aspx