How can I create a “Cross-Join” in excel?

Question

I have 2 sheets in excel, each with 10 rows. Is there some sort of "cross-join" formula/macro in Excel that allows me to create a 3rd sheet with all rows cross-joined (100 rows in total).

Answer 1

This article contains a script that might help :

Need a cross join of the rows from two excel sheets

Answer 2

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