Replace contents form 1 workbook with another based on simular data

[shabbaranks]

Hi all,

Ive attached a sample to "try" and explain what I am doing. Basically what I would like to achieve is to compare 2 spreadsheets within different workbooks which hold the same text within certain columns but different values in other columns and replace the data in say workbook 1 with whats in workbook 2.



So based on the attached, workbook 1 has simular data in row 2 except for columns B and F (TEST 2 and TEST 6) how can I get the value from columns B and F based on the matching value of column A and place it into Book 1?

Thanks!!