Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Template Wizard?
Hey guys- I am looking for a way to take a form/template (dont know the
difference) and use that for my data entry. The fields on the form would be 'linked' so to speak to the corresponding cells in my worksheet grid, and vice versa. Everyone seems to think this is difficult to do. HOWEVER- I found this in the help section in Excel, and am wondering if anyone has any experience with it and doing what I need done? "Using the Excel Template Wizard This wizard links cells in your form template to fields in a database, so that data entered using the form can be stored automatically as database records when users save copies of the form. The database can be a list on an Excel worksheet, a Microsoft Access database, or any of several supported database types." It sounds as if this wizard will do what I need done, yet, no one seems to know about it. Does anyone have experience with this who can tell me a little more about it? I also need to use my form for viewing my records on my worksheet as well as printing them out. Thanks D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 Template Wizard | Excel Discussion (Misc queries) | |||
excel template wizard | Excel Discussion (Misc queries) | |||
excel template wizard | Excel Discussion (Misc queries) | |||
excel template wizard | Excel Discussion (Misc queries) | |||
Excel template wizard | Excel Worksheet Functions |