Macros for Permutating values in three columns

I need to figure out how I can get excel to generate the list of permutations/combinations for numbers in three columns. The attached worksheet has values in three different columns (A,B,C); 10 rows for each column. I want to generate the list of permutation/combinations for all the numbers in three columns for e.g., (0.1,0.1,50), (0.2,0.1,50), (0.3,0.1,50).. and so on. Anyone know how to do this?

This should do it - it assumes no header rows and will write the combinations to sheet2 (which will be cleared first)...

Please Login or Register  to view this content.

Thanks for the Macro Andrews! But, I see the same 10 rows repeating again and again. Please see the attached worksheet.Can you help?