VBA attempt in baby steps

[gint3232]

Hi everyone,

I am attempting to build a VBA loop that'll go through all populated data in each cell with columns "A" and "B"

and in doing so move each value in these cells from A2:B2 to E2:F2, & then loop to the next row and move A3:B3 to E3:F3.. etc etc

I am not any good with VBA loops and also recording a macro does not provide an example either!! so here my pitiful vba effort so far, which is obviously useless as it stays on the same line for each loop

So question is ...How do i loop from cells A to B & C, Etc????

    Dim Cl As Range
    Dim Cnt As Long

    For Each Cl In Range("A2", Range("A" & Rows.Count).End(xlUp))
    Cnt = 2

    ''''ActiveCell.Offset(??,??).Select thought I try this but No idea how!

    Range("A" & Cnt & ":" & "B" & Cnt).Select
    Selection.Copy Destination:=Range("E" & Cnt & ":" & "F" & Cnt)
          
     Cnt = Cnt + 1
     Next Cl

many thanks for reading!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-individually-another-column.html#post5054822

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).