Macro to copy data to another workbook

[Oubok]

I have a file Breakdown Input sheet named Input Sheet. I need a macro to copy data from this workbook to a workbook called Breakdown Data sheet named Breakdown Data. I have already written part of the macro to open the Breakdown Data workbook and to select the correct row. Can someone help me please

 

[John Davis]

I have a file Breakdown Input sheet named Input Sheet. I need a macro to copy data from this workbook to a workbook called Breakdown Data sheet named Breakdown Data. I have already written part of the macro to open the Breakdown Data workbook and to select the correct row. Can someone help me please

Does this help?

Sub Oubok()
'
Workbooks("Breakdown Data.xls").Sheets("Breakdown Data").Range("A1:F3").Value = Workbooks("Breakdown Data Input.xls").Sheets("Input Data").Range("A1:F3").Value

End Sub

 

[Oubok]

Thanks John, i minupliated it slightly as i have to copy cell for cell as the cell locations are not the same.

 

[John Davis]

Thanks John, i minupliated it slightly as i have to copy cell for cell as the cell locations are not the same.

You're welcome. Thanks for the feedback.