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