I have two sheets in my excel sheet.
The first sheet has a set of calculation and analysis. The second contains all the data.
Columns C and Columns F would require to be populated from sheet 2.
My sheet 2 contains 30 different columns. I would like to pick all combinations of the 30 columns and paste it onto Columns C and F in Sheet 1.
That is every time I pick two columns from sheet 2 to paste in sheet 1. Typically I would be doing this 30C2 times.
Sheet 1 columns C and F start from row 4 onward.
Sheet 2 columns have a header in row 1 and data from row 2 onward.
Any help here would be appreciated.
Thanks
Bookmarks