Help with Macro (copying data from multiple workbooks)

T

Tim Harding

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
 
J

John Mansfield

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
 
Top