In support of this Forum post:
http://www.excelfox.com/forum/showth...ll=1#post12575


Before:
_____ Workbook: 1.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
1
 Stock Name Data Data Data Data Data Data Data Data Data Data Data Data
2
 ACC
800
700
600
500
400
300
200
100
90
80
70
3
 ADANIENT
800
700
600
500
400
300
200
100
90
80
70
4
 ADANIPORTS
800
700
600
500
400
300
200
100
90
80
70
 If there are no highlighted colour cells in the row then copy paste the firt cells of that row i. e 800(B4)
5
 ADANIPOWER
800
700
600
500
400
300
200
100
90
80
70
 and sorry Doc Sir one mistake happened from my end in providing the info to u , we have to copy and paste the data after highlighted colours cells
6
 AMARAJABAT
800
700
600
500
400
300
200
100
90
80
70
 And one more thing plz see A8 it doesnt have highlighted colour cells in that row then we have to copy and paste the first cell i. e B8(800)but A8 will not match with column B of 2.xlsx so ignore that don't do anything for that just ignore it
7
 AMBUJACEM
800
700
600
500
400
300
200
100
90
80
70
8
 ONGC
800
700
600
500
400
300
200
100
90
80
70
9
Worksheet: Sheet1
_____ Workbook: 2.xlsx ( 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
130
132.7
127.4
139.1
130.3
3
 NSE AMARAJABAT EQ
102.35
104.7
101
105.65
103.55
4
 NSE ADANIENT EQ
215.1
216.65
207.5
221.75
210.35
5
 NSE AMBUJACEM EQ
198.75
202.4
195.4
204.4
201.05
6
 NSE ADANIPORTS EQ
339.8
339.8
331.25
349.15
336.35
7
 NSE ADANIPOWER EQ
268
273.65
253.95
288.5
270.1
8
Worksheet: Sheet1
need match column A stock name of 1.xlsx with column B of 2. xlsx and if it matches then we have to copy and paste the data after highlighted colours cells in that row of 1.xlsx and paste it to column L OF 2.xlsx

If there are no highlighted colour cells in the row then copy paste the firt cells of that row i. e 800(B4)
And one more thing plz see A8 it doesnt have highlighted colour cells in that row then we have to copy and paste the first cell i. e B8(800)but A8 will not match with column B of 2.xlsx so ignore that don't do anything for that just ignore it


here is after
_____ Workbook: 2.xlsx ( 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
130
132.7
127.4
139.1
130.3
400
3
 NSE AMARAJABAT EQ
102.35
104.7
101
105.65
103.55
300
4
 NSE ADANIENT EQ
215.1
216.65
207.5
221.75
210.35
600
5
 NSE AMBUJACEM EQ
198.75
202.4
195.4
204.4
201.05
800
6
 NSE ADANIPORTS EQ
339.8
339.8
331.25
349.15
336.35
800
7
 NSE ADANIPOWER EQ
268
273.65
253.95
288.5
270.1
200
8
Worksheet: Sheet1

_.______________________

here is latest macro, in next post....