How to get all possible combinations of 2 columns of numbers into another set of 2 columns

Hello,

I am trying to get all possible combinations of column A and Column B into columns D and E, There are around 4000 numbers and it wont fit into one sheet so the results would need to go onto multiple sheets or multiple columns.

Example:
11111 22222
11112 22223
11113 22224
11114 22225
11115 22226
continuing for 4000 more sets

any help would be great

thank you

i am using excel 2010

Pl see the attached file.

Macro GetCombinations1 will fill numbers in same sheet.

The numbers will be filled in D & E Column. After the last row It will fill in G & H. Like this it continues till last no is filled.


Macro GetCombinations2 will fill numbers in different sheet.

The numbers will be filled in D & E Column

Hi,

that worked amazingly! thank you so much!

Now i have a total of 6million zip code combinations and was wondering if its possible in excel to get the driving distance from each zip code to zip code using google maps?


Thanks again