Template/database issues

[rtuck]

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]

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