VBA Code to Extract data

[Howardc]

I would like a macro to open up a source workbook and to copy the data into the destination workbook as follows:


1) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Zero Rate" appears, to be copied into col N, in the same row where the names matches the source workbook
2) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Exempt" appears, to be copied into col M, in the same row where the names matches the source workbook


I have attached sample data from the source workbook as well as the destination workbook


Your assistance in this regard is most appreciated

[Rick Rothstein]

Note: I moved your posting to the Excel Help forum where it will receive a wider audience of volunteers who can respond to it.