Excel Templates

[azlina]

I need to save the details for a template into an Excel file.

Eg: An invoice may have many items. So how do I save each items in the invoice?

Thanks in advance!

 

[Dreamboat]

Could you explain a little better/give an example?

http://www.TheWordExpert.com

 

[azlina]

Say for example I have a template that lets the user enters the Customer information such as the customer ID, name, address, etc.. then further down the template, the user enters the items that the customer buys, say 3 items. The number of items bought may vary.

So I would like to know how do I save these 3 items that the user enters in the template. I am using a template wizard to save the other fields.

Cust. ID: XXX (Able to save)
Cust. Name: XXXName (Able to save)
Cust. Addr: XXXAddr (Able to save)

Item No Qty Price
A 2 2.00 (Able to save)
B 1 3.00 (Not able to save)
C 5 10.00 (Not able to save)

I'm quite a beginner at this... maybe you can teach me a better way to save these kinds of templates. Million thanks!!

 

[Dreamboat]

Azlina:

Go download MyInvoicing from:

http://www.thewordexpert.com/tipwarez.htm

http://www.TheWordExpert.com

 

[Guest_imported]

Hi every one
Is there anyone who can tell me how can i link a template sheet within a workbook. For example i have a workbook which contains various sheets and i have the templates for those sheets so that if the sheet gets filled up, the user can insert the template of that sheet and continue filling information. I am having a problem in linking some cells on the template sheets with the orignal sheet in that workbook. For example, if the orginal sheet gets filled and user uses a template sheet, so the information like total on the template sheet should be added into the total of the orignal sheet from all the templates of that sheet. Please help me in this stuff as i am kind of new in Excel world!