Quote Originally Posted by fixer View Post
...https://www.excelforum.com/excel-pro...ml#post5340172
This link has solved the solution by considering alert.csv but now it is changed to alert.xls
The solution here, https://www.excelforum.com/excel-pro...ml#post5340172 , was optimised for using a text file as Alert.csv , using advanced Text file data manipulation techniques
There is no useful coding information there which can be applied to the current requirement : The macro from jindon is no use in the current question here.



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 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
row 3 & row 4 & row 5 will be deleted after running the macro

Before:
_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I J
1 Exchange Symbol Series/Expiry Open High Low Prev Close LTP
2 NSE ACC EQ
1183.72
1240
1161.6
1227.1
1227.1
22
 BUY
3 NSE ADANIENT EQ
139.38
141.2
136.6
138.1
140
25
 BUY
4 NSE ADANIPORTS EQ
311.85
315
306.55
310.6
312
15083
 SHORT
5 NSE ADANIPOWER EQ
33.165
34.5
32.85
33
33.2
17388
 SHORT
6 NSE AMARAJABAT EQ
594
613.5
586.9
592.55
594
100
7 NSE ASIANPAINT EQ
1584.488
1625
1555.4
1617.9
1617.9
236
 BUY
Worksheet: 1-Sheet1 9 June

_____ Workbook: Alert.xls ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I J K
1 NSE
236
6
 >
431555
 A GTT
2 NSE
25
6
 >
431555
 A GTT
3 NSE
15083
6
 >
431555
 A GTT
4 NSE
17388
6
 >
431555
 A GTT
5 NSE
100
6
 >
431555
 A GTT
6 NSE
22
6
 >
431555
 A GTT
Worksheet: Alert 9 June xls

After running macro here: https://excelfox.com/forum/showthrea...ll=1#post13733


_____ Workbook: Alert.xls ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I J K
1 NSE
236
6
 >
431555
 A GTT
2 NSE
25
6
 >
431555
 A GTT
3 NSE
22
6
 >
431555
 A GTT
4
5
6
Worksheet: Alert 9 June xls



Alan




macro.xlsm : https://app.box.com/s/z358r7tbc9hzthi539dlj49jsf4gyg8p
1.xls : https://app.box.com/s/38aoip5xi7018y9syt0xe4g04u95l6xk
Alert.xls : https://app.box.com/s/ectstkrcfnuozys9tmdd0qi3tdvyxb3w