Help with Macro (copying data from multiple workbooks)
All,
How can I set up a macro which copies data in the same column and cell but from different workbooks or worksheets..... Thanks Tim |
Tim,
This example will copy the data from range A1:A6 from Sheet1 to Sheet2 within the same workbook: Sub CopyRange1() Range("A1:A6").Copy Sheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub This example will copy the data from range A1:A6 from Sheet1 in Book1 to Sheet1 in Book2: Sub CopyRange2() Range("A1:A6").Copy Windows("Book2").Activate Sheets("Sheet1").Range("A1").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub ---- Regards, John Mansfield http://www.pdbook.com "Tim Harding" wrote: All, How can I set up a macro which copies data in the same column and cell but from different workbooks or worksheets..... Thanks Tim |
All times are GMT +1. The time now is 10:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com