Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Templates
- Thread starter azlina
- Start date
Could you explain a little better/give an example?
- Thread starter
- #3
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!!
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!!
Azlina:
Go download MyInvoicing from:
Go download MyInvoicing from:
Guest_imported
New member
- Jan 1, 1970
- 0
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!
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!
- Status