Hi Everyone,

I am completely new to this macro thing, so keep this in mind when answering

I am trying to import 4 colums from one spread sheet into another by preferably clicking one bottom in the template (or 4) and picking the file to import from.

I need to import col B into col C (in the template), col N into col F (in the template), col S to col K (in the template) and col AD to col O (in the template).

Found this code somewhere so this is where I start... 

Private Sub CommandButton1_Click()

Dim fileStr As String

fileStr = Application.GetOpenFilename()

If fileStr = "False" Then Exit Sub

Workbooks.Open fileStr

End Sub
I really hope someone can help me with this

Best regards

Lonnie