Copying data

[Brighton]

I've been trying for a while to write a code that will copy the data between two workbooks (lets say A and B) but will only copy columns A2:T2 and then down the used range. I am unsure as how to state that in the code.

Does anyone have any examples of code they got to work for copying between workbooks in Excel?

This is something I have to run once a month for monthly reports.

 

[VoG]

Something like this perhaps

Sub Sheet1_2()
Const wb2 As String = "Master"
Dim LR As Long, ALR As Long, ws As Worksheet
For Each ws In Worksheets(Array("Sanford", "Fred", "Scuttle"))
    With ws
        LR = .Cells(Rows.Count, 1).End(xlUp).Row + 1
        ALR = Sheets(wb2).Cells(Rows.Count, 1).End(xlUp).Row + 1
        .Range("A2:T" & LR).Copy Destination:=Sheets(wb2).Range("A" & ALR)
    End With
Next ws
End Sub

 

[Brighton]

I am using it to copy from BSanford to Master and I need to add in other sheets that will copy to the Master without overwriting the previous sheets copied.

 

[texasalynn]

looks like Peter understood your query and has your solution

 

[Brighton]

Thanks all! This place is awesome. I fell like an idiot not being able to figure this out but I am really grateful.