In support of this Thread
http://www.excelfox.com/forum/showth...the-entire-row

Before

_____ Workbook: sample1.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
1
 Exchange Symbol Series/Expiry Open High Low Prev Close LTP
2
 NSE ACC EQ
1014
1030
955.5
998.45
957.4
3
 NSE ADANIPORTS EQ
27.35
27.75
25.65
25.65
25.85
4
Worksheet: Tabelle1

_____ Workbook: sample2.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
1
 Exchange Symbol Series/Expiry Open High Low Prev Close LTP
2
 NSE ACC EQ
1014
1030
955.5
998.45
957.4
3
 NSE ADANIPORTS EQ
27.35
28
29
30
27.35
4
Worksheet: Tabelle2


If column H of sample2.xlsx matches with Column D then look column B data of sample2.xlsx and find that data in sample1.xlsx in column B and after getting that data in sample1.xlsx in column B , copy that entire row of sample1.xlsx and paste that in sample2.xlsx in the same row


Result:

_____ Workbook: 2.xlsx ( Using Excel 2007 32 bit )
Exchange Symbol Series/Expiry Open High Low Prev Close LTP
NSE ACC EQ
1014
1030
955.5
998.45
957.4
NSE ADANIPORTS EQ
27.35
27.75
25.65
25.65
25.85
Worksheet: Tabelle2