Hard Macro-Who wants a challenge??!?!

[joseph.minner]

Hi I need some help modifying a macro i have been using. What the macro does is takes a up to two data sets (up to 30 people):
Column A Column B
person 1 5000

2 17000

3 8000

4 19000

5 11000

6 6000

7 9000

8 22000

9 20000

10 13000

....
30 10000

and creates all the possible combinations (not permutations) of 9 between 95,000 and 100,000. (so in my book 1 ,2,3,4,5,6,7,8 and 9 are the same as 2,1,3,4,5,6,7,8 and 9)
and puts it in this format:
Inline image 1

as you can see it fills out the columns and not rows. What i need is to take this output that it is already creating and put it into rows and not columns.

So for example I would like to have the names put in the top columns
then as you go down the rows it would put the x's in each rows and this would be the unique combo of 9 instead of the columns. Also if iI run this for over 30 people i get a data overflow error. If possible can someone PLEASE PLEASE PLEASE see if they can expand this to allow up to 100 people to be input in this macro. and have the data transposed?
Here is the macro.

Please Login or Register  to view this content.

[FDibbins]

Hi and welcome to the forum

Administrative Note:

• We would love to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread title
• Please PM me when complete (Also, include a link to your thread - copy from the adress bar) and this post will be removed which will reset the replies to zero…
  
  To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title