Conditionally compare the data & delete entire row

[dumdumbum]

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

If column J of 1.xls has buy & column H of 1.xls is not greater than column D of 1.xls then match column I data of 1.xls with column B of alert.xls and if it matches then delete that entire row of alert.xls
If column J of 1.xls has a blank cell then match column I data of 1.xls with column B of alert.xls and if it matches then delete that entire row of alert.xls
If column J of 1.xls has short & column H of 1.xls is Greater than than column D of 1.xls then match column I data of 1.xls with column B of alert.xls and if it matches then delete that entire row of alert.xls



These are the three condition that macro will follow and based on that it will work
all files are located in different path, macro will be placed in seperate file macro.xlsm
sheet name can be anything

[dangelor]

Please Login or Register  to view this content.

[dumdumbum]

Dangelor Sir i am really Sorry, I made a mistake
It was not alert.csv,It was Alert.xls
I corrected the question Plz relook Sir
& Thnx for taking interest in solving this Problem

[dangelor]

Please Login or Register  to view this content.

[dumdumbum]

Please Login or Register  to view this content.

I edited the code Dangelor Sir as per my needs
Plz have a relook and let me know if any changes is required
I am getting the perfect output
Thnx Alot Dangelor Sir for solving this problem
Any suggestion regarding the change in the code is welcome

[dangelor]

If it works for you, it's good! Glad I could help!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[dumdumbum]

Sure Done Sir