Template/database issues

rtuck · Feb 27th, 2002, 08:12 AM

I have them!

I have created what will become a standard form for users to complete - there is currently only the work in progress version but as many as 30 people will need there "own".

These 30 or so will all need to be constantly completed during the working day. I need the 15 or so entries on the form to feed into a "master" spreadsheet or database. I have tried using the template wizard but seem to be a bit template incompetent.

How can i turn my creation into something that everyone has there own version of and create a database in which to record every entry.

The form lists various drop down options and sections to type, so returns a variety of values and words.

Help would be much appreciated, not got any VBA experience either.

lenze · Feb 27th, 2002, 08:23 AM

The Template Wizard should work providing everyone is on the network and has access to the drive where the database is located. It is best to have one copy of the template on a shared drive and have each person access it via a shortcut. That way, any changes can be made easily. (Hint: Password protect the Template to force the user to open it as a new workbook so they can't overwrite the template. You can not protect the worksheet in the database, but you can hide it and protect the workbook from changes if the information is sensitive)

HTH

Lenze

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 08:12 AM	#1
rtuck New Member Join Date: Feb 2002 Posts: 3	I have them! I have created what will become a standard form for users to complete - there is currently only the work in progress version but as many as 30 people will need there "own". These 30 or so will all need to be constantly completed during the working day. I need the 15 or so entries on the form to feed into a "master" spreadsheet or database. I have tried using the template wizard but seem to be a bit template incompetent. How can i turn my creation into something that everyone has there own version of and create a database in which to record every entry. The form lists various drop down options and sections to type, so returns a variety of values and words. Help would be much appreciated, not got any VBA experience either.

Feb 27th, 2002, 08:23 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	The Template Wizard should work providing everyone is on the network and has access to the drive where the database is located. It is best to have one copy of the template on a shared drive and have each person access it via a shortcut. That way, any changes can be made easily. (Hint: Password protect the Template to force the user to open it as a new workbook so they can't overwrite the template. You can not protect the worksheet in the database, but you can hide it and protect the workbook from changes if the information is sensitive) HTH Lenze