Opening a specific file and copy some cells to the last empty row

[Domosz]

Hi,

I need help with a vba. Firstly, I would like to open a specific file (name: "File 1") then copy cell A1, A3, B2, C4, C7, D2 from this file, from sheet "Profile" to another file (name: "Template"), to "Sheet1" to the last empty row together with a button on "Sheet1". Any help would be much appreciated!

 

[Ron de Bruin]

Start with the example on this page : Copy to a Database sheet with VBA