Question: Two excel files are there i.e 1 raw file & 1 master file. In both the excel files one common column. To extract data from raw file to master file using common column.

Requirement: We have to select folder & file location then using vlookup extarct data common column of master file to common column of raw file as per requirmenet of selected columns.

please help coding to automate report.

Regards,Trimal