VBA to import selective columns from a different sheet

Hello All,

I have 2 files in the same folder: source and destination files. The source files contains more columns than the destination files.
I need to import only selective columns from source to the destination where columns and all their contents will be placed in a different order. The order of columns in the source changes frequently; therefore I need to be able to import the columns based on searching the header than indicating a certain column number position in the destination. I want to write a VBA that would be triggered from the destination file without the source file opened.
Your bright minded people help would be highly appreciated.

Thanks Jindon; but I am getting error in line 13:
myHeading = "`" & Join(.Parent.Evaluate(.Rows(1).Address & "&"""""), "`, `") & "`"
The code has to be in the destination file and import silently from the source file within the same folder without opening it.
Also I don't see in your code, where would I be able to specify where specific columns from the code based on column header names would land in the destination - this is a requirement of my project.
Perhaps you can kindly clarify and help? Thank you so much!

Originally Posted by aldenes

The code has to be in the destination file and import silently from the source file within the same folder without opening it.

I thought you would run the code from other workbook.

Please Login or Register  to view this content.

Thanks for the PM and rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Jindon,

This is awesome and takes care of 99% of my problem; there's one more tweak needed, hope it's possible and not too much to ask; if the destination contains more columns than in the source I just need to leave those blank; that's important as I import only selective columns into a larger spreadsheet; please used attached as an example for destination file. I apologize not to have included this in the original problem description as I just realized.
Thank you so much!

Try change to

Please Login or Register  to view this content.

Awesome. Thank you very much!!

You are welcome.

Hi,

I have a similar question. Sorry I am very new to VBA. Like just born stage. I have a sheet which has different headings with col. That sheet is dynamic. I want to have selective data trasnfered to a different sheet. Is it possible to use the above code or can someone give me something generic? In which I can make changes to the headings myself?