In support of this post
http://www.excelfox.com/forum/showth...ll=1#post13131
It is not necessary to have all data to demonstrate the problem!!
Quote Originally Posted by DocAElstein View Post
....It is difficult in a forum to work with many rows.
Reduce the rows
We need just enough data to test.
Pick your test data carefully.
Just use a few rows. But pick your test data carefully so that it test all scenarios....
Quote Originally Posted by DocAElstein View Post
....make a small file with also row data that errors.
Explain again and show me what and where the errors are….

_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
1
 Exchange Symbol Series/Expiry Open High Low Prev Close LTP
2
 NSE ACC EQ
1182
1193
1151.7
1190.45
1156.6
22
11.566
116815
1168.166
3
 NSE DABUR EQ
499
503.75
494.5
499
499.05
772
4.9905
4941
494.0595
4
 NSE DISHTV EQ
5.1
5.15
4.75
4.95
4.75
0.0475
475
4.7975
5
 NSE UBL EQ
921
922.5
863.85
920
880.75
16713
8.8075
88955
889.5575
6
 NSE UJJIVAN EQ
170
173.5
161.6
179.55
164.1
17069
1.641
1657
165.741
7
 NSE VEDL EQ
76.8
80.25
75.7
77.6
77.95
3063
0.7795
772
77.1705
8
 NSE VOLTAS EQ
500
505
485
508.2
487.15
3718
4.8715
49202.15
492.0215
9
 NSE ZEEL EQ
150.8
152.85
143
157.55
145.15
3812
1.4515
1466
146.6015
10
11
12
Worksheet: 1-Sheet1 27Apr_2


Before

_____ Workbook: Alert.csv ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
1
 NSE
25
6
 A
2
 NSE
3812
6
 A
3
 NSE
15083
6
 A
4
 NSE
22
6
 A
5
Worksheet: Alert.

Run macro, then we have After results:

_____ Workbook: Alert.csv ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
1
 NSE
25
6
 A
2
 NSE
3812
6
 >
1466
 A
3
 NSE
15083
6
 A
4
 NSE
22
6
 >
116815
 A
5
 >
475
Worksheet: Alert.



match column I of 1.xls with column B of 2.csv

_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Row\Col
F
G
H
I
J
1
 Low Prev Close LTP
2
1151.7
1190.45
1156.6
22
11.566
3
494.5
499
499.05
772
4.9905
4
4.75
4.95
4.75
0.0475
5
863.85
920
880.75
16713
8.8075
6
161.6
179.55
164.1
17069
1.641


_____ Workbook: Alert.csv ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
3
 NSE
15083
6
4
 NSE
22
6
5
6


match column I of 1.xls with column B of 2.csv
column I of 1.xls is Empty
column B of 2.csv is Empty
Empty = Empty = Match



_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Row\Col
F
G
H
I
J
1
 Low Prev Close LTP
2
1151.7
1190.45
1156.6
22
11.566
3
494.5
499
499.05
772
4.9905
4
4.75
4.95
4.75
 Empty
0.0475
5
863.85
920
880.75
16713
8.8075
6
161.6
179.55
164.1
17069
1.641


_____ Workbook: Alert.csv ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
3
 NSE
15083
6
4
 NSE
22
6
5
 Empty
6