ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macro to build table (https://www.excelbanter.com/excel-worksheet-functions/264743-macro-build-table.html)

Victoria612

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




All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com