Before

_____ Workbook: 2.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
1
 Stock Name data data data data data data data data data data data data data data data data data data
2
 ACC
100
108
120
128
134
151
6534
30
90
97
103
3
 ADANIENT
101
109
121
127
135
122
782
40
92
98
4
 ADANIPORTS
102
110
122
16
137
177
10
50
93
99
104
5
 ASHOKLEY
1
2
3
4
5
16
137
177
6
 ANJALIPHARMA
10
50
93
99
5
102
110
122
9
10
11
7
 SUNTECK
11
12
13
14
15
16
17
18
19
20
21
22
23
8
9
Worksheet: Sheet1 (5)



After:

_____ Workbook: 2.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
1
 Stock Name data data data data data data data data data data data data data data data data data data
2
 ACC
100
108
120
128
134
151
6534
30
90
97
103
3
 ADANIENT
101
109
121
127
135
122
782
40
92
98
4
 ADANIPORTS
102
110
122
16
137
177
10
50
93
99
104
5
 ASHOKLEY
79
158
237
316
395
1264
10823
13983
6
 ANJALIPHARMA
10
50
93
99
5
102
110
122
9
10
11
7
 SUNTECK
11
12
13
14
15
16
17
18
19
20
21
22
23
8
9
Worksheet: Sheet1 (5)


Macro here: https://excelfox.com/forum/showthrea...ll=1#post13396