Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Creating and analyzing surveys using Excel?

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

    Default

    I am wondering if anyone has experience with using Excel to implement a survey? I have a project where an electronic survey would be desirable - better still, if the user's input could be tabulated in a single column on a worksheet and e-mailed back to me.

    I would appreciate hearing from anyone with experience with this...tips, pitfalls and an example would be helpful!

    Thanks in advance.

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We did this in our dept. Send your e-mail address and I'll shoot you a copy

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

    Default

    Thanks, Steve...I am looking for some further aspects of this...where the responses are collected from clicking on radio buttons or drop-down lists, then these responses automatically collected on a background data sheet, which is then automatically routed for emailing. Anyone have anything this complicate?

  4. #4
    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

    If all of the participants are internal and and have access to a shared drive, the Template Wizard with Data Tracking works wonderful. If not, you can still use the template and have them email a completed form to you . You will then have to open and save each one to update the database, but you can automate that with a macro

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

    Default

    Has anyone seen an actual functional system that does it all...collects, summarizes, compiles a summary worksheet (manual addition sounds yucky, although it beats paper-based surveys!), emails the summary sheet, etc?

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

    Default

    I would be very interested in seeing a sample of this method. I'm creating a survey to gather some benchmark data and would like create it in Excel then email it to the participants. Any help would be appreciated.

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Guys

    I was stuffed withthe task of such very crude and rubbish, yes please can you email off to JackintheUK@hotmail.com and examples, ill return if youwant, not good but few ideas in it..

    Sounds good guys..

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  8. #8
    New Member
    Join Date
    Jul 2002
    Location
    Tulsa, OK
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have had to create a survey in excel recently. What helped the most was http://www.fontstuff.com: If you will go to the download section, There is a userforms download. Very good for starting a survey form in excel.
    If you would like to peak at the excel workbook that my sister and I have been working just let me know.
    cearamerkle@yahoo.com

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
  •