VBA that can generate (Only the Report )

Using Excel 2010
Hello,

I have got VBA code which generate all possible combination form 4 sets under this link https://www.excelforum.com/excel-pro...ml#post5953979

Does is it possible…to have VBA code which can generate (Only the report) without generating all combinations as shown in the column I:M… (Only the report in column O:P) if once the report has generated I can chose min-max range easily…

Here is workbook attached with an example.

Please help.

Regards,
Moti

Originally Posted by JohnTopley

A "quick fix": using Data Dictionary might (will) be slightly quicker.

@JohnTopley, this work great! It recognizes the length of each group automatically. This is very helpful. I feel grateful for your kind help. Good luck.

Originally Posted by JohnTopley

Another example of not thinking clearly what is REALLY required!

I really accept my mistakes; I always think after I get answer for next step…next time I will be thinking all at once may be. Sorry for the inconveniences. This is solved 100%

My Best regards,
Moti