I have 2 sheets in excel, each with 10 rows. Is there some sort of "crossjoin" formula/macro in Excel that allows me to create a 3rd sheet with all rows crossjoined (100 rows in total).
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
This article contains a script that might help : 


Here is a pretty good tutorial: http://www.digdb.com/excel_add_ins/join_merge_tables_lists/ 


If using OLEDB is not an options below function can be used to generate cross product
Once above function is added to vba module,
To produce cross product of


