Hello,
Please see the attached image. currently we are doing this manually, but we would like to have a macro or a vba that will do the following:
- find value of B2 book1 in Column B of book2
- if exact match is found then copy cells C2 through D2 of book1 and paste in book2 in the row where the match was found
- repeat until all the records in book1 are done
Thanks a lot
diageminc
Please see the attached image. currently we are doing this manually, but we would like to have a macro or a vba that will do the following:
- find value of B2 book1 in Column B of book2
- if exact match is found then copy cells C2 through D2 of book1 and paste in book2 in the row where the match was found
- repeat until all the records in book1 are done
Thanks a lot
diageminc