Notes for this Post
https://excelfox.com/forum/showthrea...COPY-AND-PASTE

In 1.xls count the total number of rows that has data and copy the 3.xlsx sheet3 first row(first complete row copy) and paste that much time of 3.xlsx first row of sheet3 to 2.csv ........_
_____ 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 ADANIENT EQ
137.15
140.55
134.1
140.5
134.65
25
1.3465
13595
135.9965
4
 NSE ADANIPORTS EQ
273.95
276.95
269.55
277.6
270.65
15083
2.7065
27335
273.3565
5
 NSE ADANIPOWER EQ
32.3
32.35
30.45
32.45
30.65
17388
0.3065
3095
30.9565
6
 NSE AMARRAJA EQ
555
555
529.25
557.85
532.1
100
5.321
5374
537.21
7
Worksheet: 1-Sheet1 3Mai

_____ Workbook: 3.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
1
 NSE
6
 A GTT
2
3
Worksheet: Sheet1


_..........
suppose 1.xls has data in 5 rows then copy 3.xlsx first row of sheet3 and paste it to 2.csv 5 times

_____ Workbook: 2.csv ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
1
 NSE
6
 A GTT
2
 NSE
6
 A GTT
3
 NSE
6
 A GTT
4
 NSE
6
 A GTT
5
 NSE
6
 A GTT
6
Worksheet: 2