Sub Maybe()
Dim wb1 As Workbook, wb2 As Workbook
Set wb1 = Workbooks("1.xls") '<---- copy from here
Set wb2 = Workbooks("JunkFile.xls") '<----paste into here
wb1.Sheets("1-Sheet1").UsedRange.Offset(1).Copy wb2.Sheets("Sheet1").Range("L1")
End Sub
Sub Maybe()
Dim wb1 As Workbook
Dim Ws1 As Worksheet
Set wb1 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\1.xls")
Set Ws1 = w1.Worksheets.Item(1)
With Ws1
Ws1.UsedRange.Offset(1).Copy Ws1.Sheets("Sheet1").Range("L1")
End Sub