I found this VBA macro, that is very useful for my project and yesterday I exposed "my problem" in another forum, but without enough luck. So is a cross posting. I know that one day is shortly to have an answer, but I really need this vba. Today, after several searches with Google, I found "the owner" of this macro in this forum. And I want to try "my luck" here.
The problem - I must made one small change on this vba, but I do not know how to do. I need / want to be able to set these three constants directly in the sheet. So, I need to set my list just like in the attached picture.
I want to put in column W range W3 & last row, the n list (total number of elements)
I want to put in column X range X3 & last row, the q list (number of groups)
I want to put in column Y range Y3 & last row, the p list (number of elements per group)
Output of results start in column AS.
At this point, to get the result from the image, I need to change manually four times these constants and run for four times the macro. For this reason I need to set a list (this list may vary in number of rows), and I want to run the macro just one time to obtain that result.
If something is not explained clearly enough, feel free to ask me.
Thanks in advance for your help.
Link to Cross-Post: http://www.excelforum.com/excel-pro...13-combinations-macro-need-modifications.html
The problem - I must made one small change on this vba, but I do not know how to do. I need / want to be able to set these three constants directly in the sheet. So, I need to set my list just like in the attached picture.
I want to put in column W range W3 & last row, the n list (total number of elements)
I want to put in column X range X3 & last row, the q list (number of groups)
I want to put in column Y range Y3 & last row, the p list (number of elements per group)
Output of results start in column AS.
At this point, to get the result from the image, I need to change manually four times these constants and run for four times the macro. For this reason I need to set a list (this list may vary in number of rows), and I want to run the macro just one time to obtain that result.
If something is not explained clearly enough, feel free to ask me.
Thanks in advance for your help.
Link to Cross-Post: http://www.excelforum.com/excel-pro...13-combinations-macro-need-modifications.html
Last edited by a moderator: