Copy specific columns from one workbook to another

[reigne]

Hi All,

So I would like to ask for any help regarding my concern. Attached is the data where I will be extracting the specific column data to another workbook without opening it.

Column A - Name
Column C - Email
Column E - Team

Above are the only columns I need from first row up to last one. How do I do this in VBA?

Also, once column c is added, I would like to have another column where it will automatically be added @email.com on the end.

Thank you so much for the help!

 

[reigne]

Also, is it possible to have an option to locate the file instead of integrating it in the code?

 

[Marc L]

[…] extracting the specific column data to another workbook without opening it.

Hi !

Why not opening the workbook as it is the easy way than any beginner can achieve just using the Excel macro recorder ?‼
​

 

[reigne]

The thing is, the master file contains 20+ worksheets with different data. and the file is usually almost 2mb.

 

[Marc L]

If you need to keep the original worksheet cells formatting, destination workbook needs to be opened.​

​

If the code is located within the destination workbook so it is already opened …​

​

 

[reigne]

Oh, I think I may have not phrased it correctly. What I meant is the destination file is open but the master file where I will be copying the data will remain closed.

 

[Marc L]

It depends if you need to keep original formatting or not …​

​