Auto filling a table based upon another table

Hi ,

I am looking for a way to fill a table based upon a table I created. For example in the first columns I have a list of colors, in the second column I have a list of products and in the third column I have a choice of yes and no.
I want to create from this a list of all the possible outcomes from adding column 1 to column 2 and 3.

Thanks in advance

Thank you for the quick response.

I attached a dummy workbook with the basic idea i would like to resolve

Column E displays the output of the loop I want to run. Which is, for every cell which has a value in every colum the output should be the addition of cells together

so here the output would be a total of 9 different outcomes (3*3*3) which is cell a1+b1+c1 the next would be a1+b1+c2 and so forth.

see attachment, run macro "test", hope this helps

Works great, thanks allot. I am going to try to add more columns to the equation.

It seems to work properly only when all columns have the same amount of rows filled . I have tried using the same formula when I have over 200 rows and there is an error. There is supposed to be 5 columns. Some of the columns do not have the same amount of rows , so empty cells should be skipped. I tried adding code for the fourth and fifth column but i also recieve an error.

Thanks again for the great help

I attached the file I am working on. I have added the code for the five columns. It works well.

When I add the number 17 in cell E17 and then run the macro there is some error. I think excel is running out of memory or rows.

Is there any way around it? I don't mind if the output is to a text file with a link break between each output

if to assume that all rows have 5 values (no empty cells), number of combinations:

rows col total
3 5 243
4 5 1024
5 5 3125
6 5 7776
8 5 32768
17 5 1419857
200 5 320000000000

How large of a text file is that?

If I export and append each part of the loop to a text file will it still crash?