holliday50
New Member
- Joined
- Jul 20, 2006
- Messages
- 16
I need VB code to extrapolate the below origin & destination zip codes to show ALL possible combinations, with each combination being a separate row.
Origin Zip Dest Zip V1 V2
350-359,362 350-359,362 $1.00 $250
350-359,362 360-361,363-369 $1.00 $250
In the above example, my result should start as follows:
Ozip Dzip V1 V2
350 350 $1.00 $250
350 351 $1.00 $250
350 352 $1.00 $250
350 353 $1.00 $250
Please advise if you have any ideas. Thanks in advance for your help.
Origin Zip Dest Zip V1 V2
350-359,362 350-359,362 $1.00 $250
350-359,362 360-361,363-369 $1.00 $250
In the above example, my result should start as follows:
Ozip Dzip V1 V2
350 350 $1.00 $250
350 351 $1.00 $250
350 352 $1.00 $250
350 353 $1.00 $250
Please advise if you have any ideas. Thanks in advance for your help.
Last edited: