+ Reply to Thread
Results 1 to 2 of 2

Designing a Questionaire

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    3

    Designing a Questionaire

    Hi all,

    Would anyone be able to advise me.

    If i require a form/Questionaire designed like the following


    1) A Dropbox that enables me to select "Customer A B C etc" (I know how to do a drop box)
    2) with Each selection of customer, the questionaire would either retrieve data already input or an empty form to input.
    3) By inputting the answers to the question, it would write/overwrite data into a Master Sheet.

    I got some idea from this link http://www.excelforum.com/excel-gene...html?p=3203040

    But because of my lack of macros i cannot understand how i can modify it to meet me needs. The macro already have input to master sheet but it only creates input based on how many times u input, it does not fulfil Criteria number 2 and 3

    If there is anyway i can do this without Macros even better but im skeptical....

    Thanks for the advise, i am including workbooks before and after.
    Attached Files Attached Files
    Last edited by davesexcel; 04-22-2013 at 07:58 AM.

  2. #2
    Registered User
    Join Date
    04-18-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Designing a Questionaire

    http://www.excelforum.com/excel-gene...n-control.html

    This 1 is even closer to what i need except the data was keyed into "List" tab. Is there a way to do the input on the "Input" Sheet instead?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1