Macro to import specific data columns

[La82]

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...

Please Login or Register  to view this content.

I really hope someone can help me with this

Best regards

Lonnie

[Leith Ross]

Hello La82,

This macro will let you choose a workbook to open, either an XLSX or XLSM. The active sheet of the opened workbook will be copied to the active sheet of the workbook containing the macro.

Please Login or Register  to view this content.

[La82]

That works - thank you so much

[Leith Ross]

Hello La82,

You're welcome.