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.csv and if it matches then delete that entire row of alert.csv
If column J of 1.xls has a blank cell then match column I data of 1.xls with column B of alert.csv and if it matches then delete that entire row of alert.csv
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.csv and if it matches then delete that entire row of alert.csv



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 separte file macro.xlsm
sheet name can be anything

[jindon]

This will create new a csv file named (Original File Name_Filtered.csv) in the same folder.

Please Login or Register  to view this content.

[dumdumbum]

Thnx Jindon Sir but as i mentioned that all files are located in different path, macro will be placed in separte file macro.xlsm

So this macro needs some changes so plz relook sir

[jindon]

Please Login or Register  to view this content.

[dumdumbum]

Please Login or Register  to view this content.

I changed the code, i need something like mentioned above , i don't want any popup to select a file, it should automatically select the file
So plz have a relook Sir & help me in solving this problem Sir

[jindon]

Your change doesn't make sense.

Just post correct full name of the files.

[dumdumbum]

1.xls & Alert..csv & macro is placed in macro.xlsm

Actually i want to automate the same, using of get open file in vba will force me to select the file & i dont want that , it should automatic select file

[jindon]

What is the full path of the csv file?

[dumdumbum]

C:\Users\WolfieeeStyle\Desktop

But in future i will change that & i will edit the same in macro too..

[jindon]

Please Login or Register  to view this content.

[dumdumbum]

I haven't got any error But i am not getting any result from it
As i mentioned, row 3 & row 4 & row 5 will be deleted after runing the macro in Alert..csv file but it doesnt happened
Plz run the macro in the sample file which i attached

[jindon]

This will create new a csv file named (Original File Name_Filtered.csv) in the same folder.

..............

[dumdumbum]

I have no issue it will create a new file
But the problem is where is the output of macro , is the output of the macro matches as i mentioned in sample file that if condition match then delete entire row



I am not getting any output in the new file created by this macro

[jindon]

How can I?

Check it for yourself.

It should be in the same folder where original csv is located.

[dumdumbum]

No doubt, Sure Jindon Sir, after checking the output in the new file created by the macro, I am notifying u about the same sir
So it is my request plz have a relook & help me in solving this problem

Plz run the macro on the sample file that i have attached & then see the output

[jindon]

Missed 3 dots.

Please Login or Register  to view this content.

[jindon]

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

[dumdumbum]

Awesome Bro Awesome
Thnx Alot Jindon Sir for ur Great Help, No Doubt Problem Solved
Have a Great Day