There's no need to "quote" my post into yours, it merely clutters your own thread. (unless you're pointing out/discussing a specific line or comment, that is.) Just use the Quick Reply option instead. 
I had hoped you would take it on yourself to add the other section since it is merely a reversal of what we already did.
Option Explicit
Sub MakeCombinations()
Dim RngA As Range, RngL As Range, aVal As Range
Dim Cnt As Long, Cnt2 As Long, NR As Long
Application.ScreenUpdating = False
With ActiveSheet
Set RngA = .Range("A2:A" & .Rows.Count).SpecialCells(xlConstants)
Set RngL = .Range("L2:L" & .Rows.Count).SpecialCells(xlConstants)
Cnt = WorksheetFunction.CountA(RngL)
End With
With Worksheets.Add
NR = 1
For Each aVal In RngA
.Range("A" & NR).Resize(Cnt).Value = aVal.Value
.Range("B" & NR).Resize(Cnt).Value = RngL.Value
NR = NR + Cnt
Next aVal
Cnt = WorksheetFunction.CountA(RngA)
For Each aVal In RngL
.Range("A" & NR).Resize(Cnt).Value = aVal.Value
.Range("B" & NR).Resize(Cnt).Value = RngA.Value
NR = NR + Cnt
Next aVal
End With
Application.ScreenUpdating = True
End Sub
Bookmarks