Copy and Paste based on comparisons/Match and calculations of cells in two workbooks

[fixer]

https://www.excelforum.com/excel-pro...f-matches.html


Hi,

I am looking for a macro that doesnt the things mentioned below


If column E of book1.xlsb matches with column Z of ap.xls & column U of ap.xls is postive then match column Z of ap.xls with column B of sheet1 of book1.xlsb & if it matches then clear the data in sheet1 of book1.xlsb
macro will be placed in book1.xlsb so the path should be hardcoded in the macro

clear the data means we have to clear the data from column C of sheet1 of book1.xlsb (we dont have to delete the data of column A & Column B of sheet1 of book1.xlsb )


Thnx For the Help