Combining Sheet info

[Blauvelt]

I have 2 sheets one with Item numbers the other with Zip Codes.

I need to build zip codes for ever item number.
One Item number might have 1000 zip codes, or only 2.

Item 1 - 45801
Item 1 - 45802
Item 1 - 45803

Like so.

The finished Item and Zip needs to be on a new sheet.
This is going to be more then likely in a few cases more then 1mil lines so it will need to accommodate that also, create another sheet to continue.

 

[Blauvelt]

I have 2 sheets one with Item numbers the other with Zip Codes.

I need to build zip codes for ever item number.
One Item number might have 1000 zip codes, or only 2.

Item 1 - 45801
Item 1 - 45802
Item 1 - 45803

Like so.

The finished Item and Zip needs to be on a new sheet.
This is going to be more then likely in a few cases more then 1mil lines so it will need to accommodate that also, create another sheet to continue.

I'm looking for some VBA to build a separate sheet from 2 existing sheets in excel.

Sheet 1 has a list of Item numbers.
```
Item 1
Item 2
Item 3
```
Sheet 2 has a list of Zip Codes.
```
45801
45802
45803
```


I need to build zip codes for ever item number.
One Item number might have 1000 zip codes, or only 2.
```
Item 1 - 45801
Item 1 - 45802
Item 1 - 45803
Item 2 - 45801
Item 2 - 45802
Item 2 - 45803
```
Like so.

The finished Item and Zip needs to be on a new sheet.

The finished list may end up being more than a million lines, in that case a new sheet needs created for the remaining Item list.