I am trying to match data in two excel workbook
workbook 1, sheet 1 has
A B
1 abcde 0
2 efghp 0
3 ykiyp 2
4 abcdg 1
workbook 2, sheet 1 has
A B
1 abcdk 9
2 efgho 9
3 yjiyp 5
4 ykiyp 0
so if the first four alphabets match in column A of workbook 2 to that of workbook 1, then the value in column B of workbook 1 must be equal to that in workbook 2
Such That the final result will be
A B
1 abcde 9
2 efghp 9
3 ykiyp 0
4 abcdg 9
Any method would do vba or any other
Aucun commentaire:
Enregistrer un commentaire