How to Conditionally Copy of Column from Another Workbook

Hi,

(1) I have sample workbook named "Database" as master database, in which I have 20 columns of data for 10 items (named A to J) with each item is having data in 2 adjacent columns
(2) I have another sample workbook named my "MyWorkbook", in which I am randomly selecting some of the 10 items e.g. 5 items in Sheet1
(3) I want to copy data of both columns pertaining to this randomly selected items from my source file (i.e. Database) and paste it to respective destination cell reference mentioned in "Column C" of my target file (i.e. MyWorkbook)

For better understanding I am attaching both sample workbooks.. Can anyone help me with VBA code for this please....

Hi,

In continuation to my above post,

(1) I have tried to prepare VB code for above query, but it throws error for 2 lines.
(2) I have prepared 2 macros. Macro1 throws error at 2 lines and when I have modified these 2 lines in Macro2, it runs successfully and generates result. But it is not desired results and I want Macro1 to run successful.

Please refer revised files attached in this post and help me to resolve these both error please...

Errors are: (1) I am unable to give relative reference to columns to be copied from source workbook (2) Data can't be pasted to reference cell in target file if reference cell is not in the same worksheet

Please help to resolve this errors..

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...