clear the row data if it matches

[Zaeguzah]

Hi,
I am looking for a macro that will do the things mentioned below

If column E & column C of sheet3 of 3.xlsm matches with sheet4 of Column B & column D of 10.xlsx then match column E of sheet3 of 3.xlsm with column B of sheet1 of 3.xlsm & if matches then clear the data in sheet1 of 3.xlsm

Macro will be placed in 3.xlsm file So the path should be hardcoded in the macro, so that i can change it as per my needs
Note: we have to clear the data from column C, we will not do anything with column A & Column B of sheet1 of 3.xlsm
sheet name can be anything



Thnx Alot

[washen]

I intend to erase columns from information table that exist in another information table. Match and erase there is no such essential key for any of the record in both information table.