Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Template/database issues

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •