Macro to select multiple file from local disk and do a match case and copy next 3 columns

Hi Guys,

I am new to this forum and this is my first post.

I have a requirement to develop a macro which should let me select multiple CSV files from my local drive and perform a match case on a particular column (say column AB) using the data on the macro file and if it's a match copy the next three column data from macro file to the selected CSV file.

Example:

Macro file: Sheet1 in workbook will have a command button which on click lets you select a CSV file. Sheet2 in the workbook will have the data as below.


Andy age23 football 3
Tommy age34 baseball 5
Rick age27 Actor 2
Sam age30 singer 6

CSV file: This file will have the names in column say AB, the macro file should do a match case similar to vlookup and if it finds a match move the next three column from the macro sheet2 to csv file on AC,AD and AE respectively.


Looking forward for your advice.

Regards,
Sinser

No i don't have the sample file with me now.. Let me know if you have any specific question..

Hi,

I have attaced the sample file.

Regards,
Sinser

Hi Arlette,

I got to the part where i can open multiple sheet, but i am clueless after this. Please help

Regards,
Sinser

Uploaded samplefile

Hi Arlette,

You can give me the code as per the attached sample file, the original is too big and has some sensitive data which i cannot upload on internet.

Regards,
SINSER