If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macro to build table
I have 6 questions that may be answered yes or no, and for the sake of
keeping everything in integer form, let's assume "1" for yes and "0" for no. Depending on how a customer answers all 6 questions, they will receive a predetermined score. I am attempting to develop the answer key, so-to-speak, to refer the reps to once they are finished asking the customer these questions. I was hoping for the code that would build a macro to create this tabe for me - a table that would lay out all of the 6 question-answer combinations, like the following: Questions Scenario 1 Scenario 2 Scenario 3 Scenario 4 1 1 1 1 1 2 1 0 0 0 3 1 1 0 1 4 1 1 1 0 5 1 1 1 1 6 1 1 1 1 ....and so on, so that I am given all the possible 6 answer scenarios.... Your help is greatly appreciated! Victoria |
Thread Tools | |
Display Modes | |
|
|