Re: VBA Code - Generate a list of all combinations possibles
Hi mikerickson
If I wanted to achieve the exact same thing but to have it as a sub (code with a button) instead of a function. How might this look?
Cheers
Posts by alexlimmy
-
-
Re: VBA Code - Generate a list of all combinations possibles
Thanks a bunch. This works a treat. Cheers.
-
Hi.
Using a VBA Code, I'm looking generate a results list of all combinations (in individuals cells) from a list of variables across 4 different columns . Please find below an example;
Initial list of variables:
[tr]
[TABLE="width: 500"]
[td]Column A
[/td]
[td]Column B
[/td]
[td]Column C
[/td]
[td]Column D
[/td]
[/tr]
[tr]
[td]1
[/td]
[td]4
[/td]
[td]7
[/td]
[td]9
[/td]
[/tr]
[tr]
[td]2
[/td]
[td]5
[/td]
[td]8
[/td]
[td]10
[/td]
[/tr]
[tr]
[td]3
[/td]
[td]6
[/td]
[td][/td]
[td][/td]
[/tr]
[/TABLE]Final results:
[TABLE="width: 500"]
[tr]
[td]Result 1
[/td]
[td]Result 2
[/td]
[td]Result 3
[/td]
[td]Result 4
[/td]
[/tr]
[tr]
[td]1
[/td]
[td]4
[/td]
[td]7
[/td]
[td]9
[/td]
[/tr]
[tr]
[td]2
[/td]
[td]4
[/td]
[td]7
[/td]
[td]9
[/td]
[/tr]
[tr]
[td]3
[/td]
[td]4
[/td]
[td]7
[/td]
[td]9
[/td]
[/tr]
[tr]
[td]1
[/td]
[td]5
[/td]
[td]7
[/td]
[td]9
[/td]
[/tr]
[/TABLE]Thanks for any help in advance.