Creating an automatic statement in Excel

[lerpo]

Ok, so im fairly new to Excel
I have been asked to create a spreadsheet with the following tables;

Customer Details
Product Details
Items the customer has bought
Statement

There are a few other rules that I need to sort out but that can be done later :D

My problem at the momnet is that currently the statement is static, so if i add a new item to the item table, and then add the amount that the customer has bought, the statement needs to create a new line with the information on, please for god sakes help! haha
Many thanks! x

 

[Tinbendr]

Your request is too vague to offer any meaningful solutions.

There are many templates on Microsoft's site catered to this request. Perhaps you could start there.

 

[GK039]

What do you want to be displayed in the statement line for any new product or item?

Ok, so im fairly new to Excel
I have been asked to create a spreadsheet with the following tables;

Customer Details
Product Details
Items the customer has bought
Statement

There are a few other rules that I need to sort out but that can be done later :D

My problem at the momnet is that currently the statement is static, so if i add a new item to the item table, and then add the amount that the customer has bought, the statement needs to create a new line with the information on, please for god sakes help! haha
Many thanks! x