Copy columns from one workbook to another

[sco315]

Hello, I am new to Macros and have no idea how to program what I need to.

I have a master spreadsheet on a shared drive, and a separate file on my local drive. I want to copy columns A, C, W, J, and V (in that order) from the 2nd worksheet (tab) in the shared excel file and copy it to columns A:E in the local excel file. I also want to create a button on different worksheet in the local excel file that refreshes those columns so the latest data is copied over.

Thank you

 

[onlyadrafter]

Hello,

something like this perhaps?

Sub COPY_FROM_WORKBOOK()
    Columns("A:E").ClearContents
    Workbooks.Open ("C:\Workbook2.xls")
    Application.ScreenUpdating = False
    Range("A:A,C:C,W:W,J:J,V:V").Copy
    Workbooks("Workbook1.xls").Activate
    Range("A1").PasteSpecial (xlPasteValues)
    Columns("C:C").Insert
    Columns("F:F").Cut Range("C1")
    Application.ScreenUpdating = True
End Sub

you will need to rename the filenames and location.