VBA to copy data from master workbook to another

[vinidis]

Hi everyone!

I have a problem with the following task:
I have a master workbook where I record my data in 9 columns (B4:B54 to I4:I54) each has a header. I'd like to copy the values from this sheet to another workbook (Data).
I've tried the Range method, but it works only with one cell.

Can anyone help me with this?

Thanks in advance.

 

[JefferyLi]

Workbooks("Source WB name").Worksheets("Source WS name ").Columns("B:I").Copy
Workbooks("Destination WB name").Worksheets("Destination WS name").Range("A1").PasteSpecial Paste:=xlPasteValues