Macro for transferring data from one excel to different excel [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hi

I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport", "Column" = M2, N2, O2 (till Last)

TO

"Book"= "New", "sheets" = "work allotment", "colum" = I2, J2, K2

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
try something like this macro test(not tested)-keep both workbooks open


Sub test()
With Workbooks("temp.xlsx")
    With .Worksheets("auditreport")
        Range(.Range("M2"), .range("O2").End(xlDown)).Copy
        Workbooks("new").Worksheets("work allotment").Range("I2").PasteSpecial
    End With
End With

End Sub