Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Help generating combinations

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating a list of all possible number/letter combinations orion Excel Programming 4 November 27th 16 10:36 PM
Generating Possible Combinations and Assigning ID Number Joe Kluck Excel Worksheet Functions 2 March 28th 10 10:58 PM
Generating excel combinations mark4006 Excel Discussion (Misc queries) 2 March 6th 05 04:40 PM
Function generating all possible combinations of set of numbers Lucia Excel Worksheet Functions 1 February 7th 05 10:41 PM
a problem in generating a list of all of the possible combinations of those words chipper Excel Programming 5 October 31st 04 01:31 PM


All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"