Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro does not run when data refreshed | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |