Dow 30 Combination Experiment

[CarlsEra17]

Hello,

This is my first time here and my first post. I want to design an experiment where I test 2, 3, 5, & 6 Dow stock combinations and paste the names and result values on another page in a macro.

I'm so new to VBA, so I'll describe this as best as possible.

Sheet 1 contains the formula/methodology/process,
where for a 2 stock combination, Column A = dates, Column B = Stock 1,
Column C = Stock 2, D1 = result 1 (max cap) and E1 = result 2 (max dd).

Sheet 2 contains the data
where Column A = Stock 1 and Column AD = Stock 30
where Row 1 = Stock Name, rows 2 and down are data.

Sheet 3 contains each combination and result,
i.e. a1 = stock 1, b1 = stock 2, c1 = result 1, d1 = result 2
a2 = stock 1, b2 = stock 3, c2 = result 1, d2 = result 2

and so on.

For simplicity's sake, say I wanted to test the 3 stock combination, I would use a new workbook and have
Column A = Dates, Column B = Stock 1, Column C = Stock 2, Column D = Stock 3, E1 = Result 1, F1 = Result 2.

I would like to understand the 2 stock combinations before moving on to 3, 5 & 6.

Thanks for your patience, I'm in no hurry to complete this experiment and any help is greatly appreciated. Also, would testing 10 & 15 combinations be too unwieldy? Thanks again.