Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Tom,
Thanks for your response, but the challenge for me is to write the code dynamic enough, so that the user can update the input range with new data and re-run the same code to rebuild the combinations sheet. You see, you coded 3 FOR LOOPs because you know ahead of time that there are 3 question type categories. I want the code to determine the number of question type categories and generate the combinations at run time. To give a little more background. Once the combinations are generated I will have code to place some HLOOKUP VLOOKUP formulas in the colums to the right of the combinations. This part of the problem I think I can code fairly easily. Once again thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Generating a list of all possible number/letter combinations | Excel Programming | |||
Generating Possible Combinations and Assigning ID Number | Excel Worksheet Functions | |||
Generating excel combinations | Excel Discussion (Misc queries) | |||
Function generating all possible combinations of set of numbers | Excel Worksheet Functions | |||
a problem in generating a list of all of the possible combinations of those words | Excel Programming |