Macro for transferring data from one excel to different excel
Closed
Gokul
-
Feb 2, 2015 at 11:17 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 3, 2015 at 12:42 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 3, 2015 at 12:42 AM
Related:
- Macro for transferring data from one excel to different excel
- Transfer data from one excel worksheet to another automatically - Guide
- Spell number in excel without macro - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Download macros for excel - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 3, 2015 at 12:42 AM
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
