Commbinations with VBA

[teodormircea]

Hello Forum

I have this values that i want to make all combination possibles

I have columns from A to R, so a lot of columns. I want to combine the values from the columns.

I have this code that i modified, not an expert, but is not working. Need some help

Please Login or Register  to view this content.

[OllieB]

No really sure what you are trying to achieve here, but the below code would provide the same output

Please Login or Register  to view this content.

[teodormircea]

Hello There

Here are my columns .

7691058AD6AA0.jpg

I need all possible permutation with the values for the given columns.

[OllieB]

I am sorry but I do not understand what you are asking for.

[teodormircea]

Hello There

Here are my columns .

Attachment 270448

I need all possible permutation with the values for the given columns. Alo the macros should take only values, and ignore the balnks

[teodormircea]

I want to combine all values and make a list of all possible permutations.

[teodormircea]

Here an example af permutation with values from 4 columns
0-3 t <K$100 B YES -dep YES -dep
0-3 t <K$100 B YES -dep NO - dep
0-3 t <K$100 B NO -dep YES -dep
0-3 t <K$100 B NO -dep NO - dep
0-3 t K$100-K$500 B YES -dep YES -dep
0-3 t K$100-K$500 B YES -dep NO - dep
0-3 t K$100-K$500 B NO -dep YES -dep
0-3 t K$100-K$500 B NO -dep NO - dep
0-3 t K$500-K$1000 B YES -dep YES -dep
0-3 t K$500-K$1000 B YES -dep NO - dep
0-3 t K$500-K$1000 B NO -dep YES -dep
0-3 t K$500-K$1000 B NO -dep NO - dep
0-3 t >K$1000 B YES -dep YES -dep
0-3 t >K$1000 B YES -dep NO - dep
0-3 t >K$1000 B NO -dep YES -dep
0-3 t >K$1000 B NO -dep NO - dep
0-6 t <K$100 B YES -dep YES -dep
0-6 t <K$100 B YES -dep NO - dep
0-6 t <K$100 B NO -dep YES -dep
0-6 t <K$100 B NO -dep NO - dep
0-6 t K$100-K$500 B YES -dep YES -dep
0-6 t K$100-K$500 B YES -dep NO - dep
0-6 t K$100-K$500 B NO -dep YES -dep
0-6 t K$100-K$500 B NO -dep NO - dep
0-6 t K$500-K$1000 B YES -dep YES -dep
0-6 t K$500-K$1000 B YES -dep NO - dep
0-6 t K$500-K$1000 B NO -dep YES -dep
0-6 t K$500-K$1000 B NO -dep NO - dep
0-6 t >K$1000 B YES -dep YES -dep
0-6 t >K$1000 B YES -dep NO - dep
0-6 t >K$1000 B NO -dep YES -dep
0-6 t >K$1000 B NO -dep NO - dep
1 t <K$100 B YES -dep YES -dep
1 t <K$100 B YES -dep NO - dep
1 t <K$100 B NO -dep YES -dep
1 t <K$100 B NO -dep NO - dep
1 t K$100-K$500 B YES -dep YES -dep
1 t K$100-K$500 B YES -dep NO - dep
1 t K$100-K$500 B NO -dep YES -dep
1 t K$100-K$500 B NO -dep NO - dep
1 t K$500-K$1000 B YES -dep YES -dep
1 t K$500-K$1000 B YES -dep NO - dep
1 t K$500-K$1000 B NO -dep YES -dep
1 t K$500-K$1000 B NO -dep NO - dep
1 t >K$1000 B YES -dep YES -dep
1 t >K$1000 B YES -dep NO - dep
1 t >K$1000 B NO -dep YES -dep
1 t >K$1000 B NO -dep NO - dep
>1 t <K$100 B YES -dep YES -dep
>1 t <K$100 B YES -dep NO - dep
>1 t <K$100 B NO -dep YES -dep
>1 t <K$100 B NO -dep NO - dep
>1 t K$100-K$500 B YES -dep YES -dep
>1 t K$100-K$500 B YES -dep NO - dep
>1 t K$100-K$500 B NO -dep YES -dep
>1 t K$100-K$500 B NO -dep NO - dep
>1 t K$500-K$1000 B YES -dep YES -dep
>1 t K$500-K$1000 B YES -dep NO - dep
>1 t K$500-K$1000 B NO -dep YES -dep
>1 t K$500-K$1000 B NO -dep NO - dep
>1 t >K$1000 B YES -dep YES -dep
>1 t >K$1000 B YES -dep NO - dep
>1 t >K$1000 B NO -dep YES -dep
>1 t >K$1000 B NO -dep NO - dep

[OllieB]

I understand what you need by I do not have the time at present to write a solution. Perhaps someone else can help

[teodormircea]

This code seems to work for a reduced number of columns, but it takes also the blank space in consideration, how can ask the macro to ignore the blanks

Please Login or Register  to view this content.