Hello!
I would like to compare values between two different workbooks and if these values match, I need to copy specific cells from the second workbook to the first one.
In Short:
Workbook A
Contains a sheet called "Contacts"
Inside "Contacts", from A2 to A.... I have the contacts name
Workbook B
Contains a sheet called "Contracts"
Inside "Contracts", from E2 to E... I also do have the contacts name
What I need is to compare these values from different workbooks and if the values between workbook A, sheet Contacts, A... matches with workbook B, sheet Contratcs, E.... then I should copy the columns A and F from the respective row (workbook B) and then paste it to workbook A.
Can anynone help me with this?
Any help will be appreciated guys!
Regards
I would like to compare values between two different workbooks and if these values match, I need to copy specific cells from the second workbook to the first one.
In Short:
Workbook A
Contains a sheet called "Contacts"
Inside "Contacts", from A2 to A.... I have the contacts name
Workbook B
Contains a sheet called "Contracts"
Inside "Contracts", from E2 to E... I also do have the contacts name
What I need is to compare these values from different workbooks and if the values between workbook A, sheet Contacts, A... matches with workbook B, sheet Contratcs, E.... then I should copy the columns A and F from the respective row (workbook B) and then paste it to workbook A.
Can anynone help me with this?
Any help will be appreciated guys!
Regards