lundi 30 mars 2015

Excel VBA checking the condition and if satisfied adding data

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