Macro to copy Data from Sheet1 from tow 3 in Col A & B to after last column on sheet 2

[Howardc1001]

I have tried to amend some code so as to copy data from row3 in Col A & B and paste this after last Column on Sheet2, but cannot get a run time error "object required"

Please Login or Register  to view this content.

Your assistance in this regard is most appreciated

[BrianM45]

Hi Howardc1001

May be like this

Please Login or Register  to view this content.

[Fluff13]

Maybe

Please Login or Register  to view this content.

[Marc L]

(remove as misreading, come back in a while)

[Marc L]

As a beginner starter :

Sub Copy_Data() 
         C% = Sheet2.UsedRange.Columns.Count + 1 
    With Sheet1.[A3].CurrentRegion 
        .Copy Sheet2.Cells(C) 
         Sheet2.Cells(C).Resize(.Rows.Count, .Columns.Count).Columns.AutoFit 
    End With 
End Sub  

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[Howardc1001]

Thanks for the help Guys

[Fluff13]

You're welcome & thanks for the feedback