kiranbvsn
08-20-2017, 08:09 AM
Hi Team,
Need vba sub or function for the below requirement.
I got three excel sheets, with 5 columns in each sheet.
I need to search the first column (which is company name) on sheet1 against other two sheets column1, here names are not consistent
for example
sheet1: column1: has "ABC Ltd" and
sheet2:column1 has "ABC" but
sheet3;column1 (which is standard for names is ABC US Limited).
This way I need to copy the data in other columns from sheet2 (if data matches) to sheet 1.
Can you please help.
Need vba sub or function for the below requirement.
I got three excel sheets, with 5 columns in each sheet.
I need to search the first column (which is company name) on sheet1 against other two sheets column1, here names are not consistent
for example
sheet1: column1: has "ABC Ltd" and
sheet2:column1 has "ABC" but
sheet3;column1 (which is standard for names is ABC US Limited).
This way I need to copy the data in other columns from sheet2 (if data matches) to sheet 1.
Can you please help.