Looping Through Two Columns

[homerl2409]

I have two columns: A & B. Column A has a list of Items and Column B has a list of dates.

What I am trying to do in Excel VBA is copy everything that's in column A into another sheet and then copy each cell on column B alongside each value in column A until everything in column B has been copied. Like this:

I don't know where to start. Please help

I also posted here: Looping Through Two Columns, Looping Through Two Columns in Excel VBA, and on Reddit

 

[homerl2409]

Anyone please???

 

[Fluff]

How about

Sub homerl()
   Dim Rng As Range, Cl As Range
   Dim Nxtrw As Long
   Nxtrw = 1
   With Sheets("Sheet1")
      Set Rng = .Range("A1", .Range("A" & Rows.Count).End(xlUp))
      Rng.Copy Sheets("Sheet2").Range("A1").Resize(Rng.Count * .Range("B" & Rows.Count).End(xlUp).Row)
      For Each Cl In .Range("B1", .Range("B" & Rows.Count).End(xlUp))
         Sheets("sheet2").Range("B" & Nxtrw).Resize(Rng.Count).Value = Cl.Value2
         Nxtrw = Nxtrw + Rng.Count
      Next Cl
   End With
End Sub

 

[Fluff]

Anyone please???

Give us a chance, you only posted the question 9 minutes before bumping it
All you do by that is reduce your chances of getting help.