The following code creates every 10 stock ticker combination from the list of 15 total in A3:A17and copies them to a new worksheet. Is there a way to change the code to create every 10, 11, 12, 13, 14 and 15 stock combination?
I would always like 10 to be the minimum number of stocks in each combination. If there are 20 total in the list (A3:A22) than create every 10-20 stock combination..ect
Please Login or Register to view this content.
If you change the value of A2 to 11, it will do groups of 11. Change it to 12, you get twelves...etc.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That will work but everytime I change the value in A2 and run the macro it creates a new worksheet. How can the code be changed to add the groups all to the same worksheet.
Lets call the worksheet with the consolidated data "Combinations"
Run that code as many times as you wish, then run this to merge the resulting sheets.
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-01-2010 at 03:16 PM.
I appreciate your suggestion but is there a way to re-write the code to avoid the creation of new worksheets? I have to run this procedure hundreds of times and to continuously keep deleting new worksheets that have been created will become tedious
That would be a pretty huge project to rewrite that whole thing. That's why I use it as is, when I use it.
Okay so I guess that will suffice.
I noticed an error in the combination code. If the total number is 15 and the number chosen is 2 then there should be 105 combinations. If the total number is 15 and the number chosen is 3 then there should be 455 combinations.
Each new sheet has 105 and 455 new combinations respectively after running the ListPermutationsOrCombinations code. However when I run the Consolidate code it only combines 455 rows of data instead of 560 rows.
Error in the code I wrote for incrementing the columns.
Please Login or Register to view this content.
are you saying to remove the + 1?
This is my code and it is not working...
Please Login or Register to view this content.
All of the combinations should be in column A
N/M I figured it out. Thanks for your help!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks