I've written a certain algorithm which takes say 10 inputs (in 10 adjacent cells), does some calculations and provides say 12 outputs. For testing the algorithm, I am able to specify each combination of these 10 inputs, get the 12 outputs and copy them in a different worksheet, but I need to run say 100 different combinations of these 10 inputs. If I can provide these inputs in a 10 columns*100 rows format, is there a way to get output in 12 columns*100 rows format ?

Thanks in advance.

Raj