Page 1 of 2 1 2 LastLast
Results 1 to 10 of 16

Thread: Advice on forms and database

  1. #1

    Advice on forms and database



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all. Let me start by saying that I am a complete novice in the world of excel.
    I work in a small company who, for compliance need to complete a small set of yes/no type questions. We complete about a dozen of these each week on a paper form and then the answers are then input into excel to keep the results and create some colourful graphs.I have been charged with trying to improve this process!
    What I would like some help on, is how I can replicate the form on an excel sheet and get the data that is input in the form, to somehow store itself in a seperste area so that we can keep a complete record.
    I have tried numerous searches on the Microsoft site, but I'm afraid that I'm really not understanding and am hoping that someone may be able to give me a real idiot guide type explanation on how I can about this little project.
    We use offIce 2010, which I think is important to let you know. If anyone can help I would be extremely grateful.
    Thanks in advance.

  2. #2
    When you say you want to save the data in a seperate area, do you mean you want to get the data into a database like Access or do you mean you want to get the form data onto a seperate worksheet?

  3. #3
    I would like to keep it in excel in a kind of database, so that we can continue using the same sort or reporting process.
    By different area, I just meant another spreadsheet or the like do that when someone completes a form online, they only deal with that form and not the collected data.
    Thanks again.

  4. #4
    Take a look at this and see if this may be close to what you need.

    Note:
    the number of questions can be adjusted
    you answer by clicking in the cell and you just select yes or no.
    i added a date and time for each question so you could sort or filter the data on sheet2

    This contains Macro code so you will need to allow or enable macros for this to work

    click the clear answers button to ready form to be filled out. when answers are complete click the save form button. it will copy the data over into
    sheet 2 into the next available row.
    Attached Files Attached Files

  5. #5
    Thanks very much for the attachment. I haven't actually got 2010 at home, so I will take a look at work today. I really appreciate your help and I'll update again later. Thanks again.

  6. #6
    Ok, this is just the sort of thing, but now having opened it and played around a little I have a couple more questions if I may :
    1.If I add a line it only takes the first ten lines into sheet 2
    2.The date field automatically fills in the current date and time on all records in sheet 2, can it be held at the original date and time?
    3.How can I access the macros to try and get a better understanding of what goes where and how they work?

    Thanks agaIn for your help so far.

  7. #7
    Sorry I jumped in without doing some proper research. Therefore please ignore questions 1 & 3, but I'd still appreciate some advice on Q2.

    Thanks in advance.

  8. #8
    OOOOPS .... I forgot about it taking the date formula on the copy/paste. We can get around that by just pasting the values only . you will lose the color format but that probably is no big issue, i am sure you are more concerned with getting the data in there . I also added some safety valves in the code. i know i like having these in place myself. It will pop a message box up asking if you want to continue with the job. sometimes you click without thinking and this just makes you stop and make sure you want to go ahead with the operation. If you got any other questions or format changes you need to make let me know i don't mind helping.
    Attached Files Attached Files

  9. #9
    updated the code a litle more for you.... I thought in case you have to add questions in the future this file keeps you from manually having to change the code to copy the new rows you added, the code will pickup the new rows and copy/paste them automatically.
    Attached Files Attached Files

  10. #10
    Once again thanks for getting back to me and for the time you have obviously invested in my little project. I'm at home again now, so unable to look at them, but I will do first thing in the morning
    Thanks again, it's much appreciated.

Page 1 of 2 1 2 LastLast

Posting Permissions

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