How to Conditionally Copy of Column from Another Workbook

Hi Marvin,

Thanks a lot for your concern and help.

Now I am able to solve query on my own. You may save both attachments and make necessary changes in file path in Macro and run the macro to see what I was exactly looking for. I have also added some more lines in code to deal with blank cells and values which are not found in source file. Also I have added small VB code to remove blank columns from target file output sheet. Please note that this is a sample file for my learning purpose, where I have only put hypothetical data, but based on this VB code, I can apply the same in my actual file.

Further I would like to add that I have not taken any training/education on VB or excel. I am a MBA and doing all these just based on guidance from Honorable Gurus like you and others on this and such similar forums, you tube excel and VB tutorial videos and finally applying my efforts and logical skills to get final results.

Because of above fact, my VB code might not be as per standard good practices of VB and suggestions from you to improve it for my learning is always welcome.

Once again thanks a lot...