Copy specific columns from all the files in the folder and combine those columns in sheet

[JaffarAhamed]

Dear Gurus,
I got the below code that it combine sheets from all the files in the folder copy to another workbook, the code works well. But i want to copy specific columns from all the files, I tried but i cannot able to get. Can you help me here please.
I think there is no need for attachment. Can you asssume that there are 25+ files in a folder other folder path and result should come in the sheet1 in active workbook. If you still want sample files then i can share. thanks.

Please Login or Register  to view this content.

[JaffarAhamed]

Below is the column header should consider from all the files in the folder

Please Login or Register  to view this content.

otherwise the code could be the list where i can add column headers in other sheet

[Marc L]

Hello,

as I can't stand how it is possible your code 'works well' so I can't give it a try without the necessary workbooks (code & source data) …

[maxpit]

Hello JaffarAhamed,

your code reported in post #1 only takes care of:

• searching the files;
• opening them;
• importing all the columns from A to AA by pasting only the value of the cells.

Next I detect the presence of "CopyColumnsByName" whose purpose escapes me.

If your intention is to extract only some columns (as in post 2), you should create a sheet where you will insert the desired columns and copy, after searching the open files, only the values of those.

Bye

[6StringJazzer]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #2 about thread duplication.

I am closing this thread, but you may continue here in the original thread

Thread closed.