Copying & Pasting specific dynamic range of columns into different workbook?

[PJohnson_Construction]

Hello,

I am having difficulties with what should be an easy macro....

I am trying to link two workbooks so that specific column values(only) get pasted into active workbook when activated by command button.

Source wkb: "Inventory Master List (Macro)"
Destination wkb: "Inventory Check (Macro)"

Columns to transfer value:
Source wkb: 1, 2, 3, 4, 9
Destination wkb: 1, 2, 3, 4, 5 (by command button located in this wkb)

The range can amass up to 300 rows.

Any help is VERY MUCH APPRECIATED!!!

Thank you in advance,
-PJ

 

[footoo]

Dim dWS As Worksheet, sWS As Worksheet
Set dWS = Workbooks("InventoryCheck (Macro)").Sheets("Sheet1")
Set sWS = Workbooks("Inventory Master List (Macro)").Sheets("Sheet1")
dWS.[A:E] = sWS.[A:E].Value
dWS.[I:I] = sWS.[I:I].Value

 

[PJohnson_Construction]

Thank you @footoo!!! One or two little tweaks and it is working like a dream!!!

Thank you so much! I am still learning VBA so some things haven't clicked yet.

Cheers,
PJ