VBA code to import data from workbook 1 to workbook2

[KingSwish828]

Is there a VBA code that I can use to import data from one workbook to another workbook?

1st workbook data will start on sheet2, A1:A36 (workbook name is josmithjan11wk1)

The data on my first workbook will need to be placed in workbook Monthly QA josmith and it must be placed in P37

How can go about doing thi in excel 2007s?

 

[John Davis]

Is there a VBA code that I can use to import data from one workbook to another workbook?

1st workbook data will start on sheet2, A1:A36 (workbook name is josmithjan11wk1)

The data on my first workbook will need to be placed in workbook Monthly QA josmith and it must be placed in P37

How can go about doing thi in excel 2007s?

Maybe something like this?

Sub KingSwish828()

Workbooks("josmithjan11wk1.xls").Sheets("Sheet2").Range("A1:A36").Copy Workbooks("Monthly QA josmith.xls").Sheets("Sheet1").Range("P37")
End Sub