Open Second Excel via Explorer and Copy Certain Columns

[Yugo101]

Hey Everyone,

Wondering if anyone can help me with my question. This is for Excel 2010, work related.

I have 2 excels which i use. 1. Customer 2. Info.

Basically i want something where i can open Customer excel and press a button to open file explorer to select the info excel and copy X columns from that and paste into the customer excel. At the moment i am manually copy and pasting the column from info to customer and I am sure there a easy way to do it. Info excel has multiple sheets i have to copy from.

Many Thanks,

 

[Candyman8019]

If it is always the same range that you're copying, you could use the macro record feature. Works pretty slick.

 

[Yugo101]

Yeah it will always the same range, 5 different columns that need copying.

Just need help with the coding to make it work.

 

[Yugo101]

So Idea is to have a button, which when you press i can find what excel i want to copy data from and let the magic happen.