Hello,
I am asking guidance with a following issue and would be very grateful if someone could push me towards right direction:
I have source table (1) with example data below.
Then I have table in another workbook (2) which doesn't have in columns C&D filled but but it could have same information in columns A:B and E:F as in source file.
I would like to create a macro that would compare workbook 1 and 2 and if duplicate values are found in columns A:B and E:F it would then copy and paste data from columns C:D from workbook 1 to workbook 2 as well.
Any kind of tips are welcome.
I am asking guidance with a following issue and would be very grateful if someone could push me towards right direction:
I have source table (1) with example data below.
Then I have table in another workbook (2) which doesn't have in columns C&D filled but but it could have same information in columns A:B and E:F as in source file.
I would like to create a macro that would compare workbook 1 and 2 and if duplicate values are found in columns A:B and E:F it would then copy and paste data from columns C:D from workbook 1 to workbook 2 as well.
Any kind of tips are welcome.