Previous Topic Next Topic

Macro for transferring data from one excel to different excel

Closed
Gokul - Feb 2, 2015 at 11:17 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 3, 2015 at 12:42 AM
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
Related:

1 reply

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 3, 2015 at 12:42 AM
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
0