sear paisan
New Member
- Joined
- Feb 17, 2005
- Messages
- 7
I want tranform data from sheet1 to sheet 2
What is the code in sheet2 ? When I put data of AOT in sheet1
it will show only data of AOT in sheet2 automaticaly.
Sheet1
BUY
Date Stock Price Volume Total
25/12/2003 LOXLEY 53.50 4,000 214,572.45
06/01/2004 BCP 19.20 10,000 192,513.60
06/01/2004 EGV 11.80 5,000 59,157.83
09/01/2004 SIM 22.20 10,000 222,593.85
09/01/2004 EIC 19.80 2,000 39,705.93
12/01/2004 TT&T 5.95 10,000 59,659.16
12/01/2004 KGI 6.50 20,000 130,347.75
13/01/2004 Q-CON 19.70 4,000 79,010.79
13/01/2004 Q-CON 20.30 3,000 61,062.91
16/01/2004 KEST 69.00 10,000 691,845.75
30/01/2004 ZMICO 11.30 50,000 566,511.38
04/02/2004 ZMICO 11.70 50,000 586,564.88
04/02/2004 ZMICO 11.70 50,000 586,564.88
05/02/2004 CK 21.50 50,000 1,077,875.63
06/02/2004 CK 21.50 50,000 1,077,875.63
06/02/2004 ZMICO 12.90 60,000 776,070.45
06/02/2004 SCB-W 12.20 46,800 572,487.32
06/02/2004 SCB-W 12.20 3,200 39,144.43
06/02/2004 ZMICO 12.90 40,000 517,380.30
10/02/2004 SCB-W 12.60 43,000 543,249.32
10/02/2004 SCB-W 12.60 7,000 88,435.94
11/02/2004 SCB-W 13.20 50,000 661,765.50
12/02/2004 SCB-W 13.50 17,000 230,113.91
12/02/2004 SCB-W 13.50 3,000 40,608.34
16/02/2004 SCB-W 13.70 50,000 686,832.38
11/02/2004 SCB-W 13.20 50,000 661,765.50
24/02/2004 bay 11.90 10,000 119,318.33
24/02/2004 bay 11.80 40,000 473,262.60
01/03/2004 itd 105.00 5,000 526,404.38
11/03/2004 AOT 42.00 500 21,000.00
11/03/2004 AOT 45.75 50,000 2,293,619.06
11/03/2004 AOT 46.00 50,000 2,306,152.50
11/03/2004 AOT 48.00 10,000 481,284.00
12/03/2004 aot 47.00 50,000 2,356,286.25
12/03/2004 aot 47.50 10,000 476,270.63
02/04/2004 scib-c1 5.20 200,000 1,042,782.00
02/04/2004 scb-w 8.30 100,000 832,220.25
02/04/2004 scb-w 8.30 50,000 416,110.13
05/04/2004 kest 56.00 30,000 1,684,494.00
Sheet2
AOT
Date Price Volume Total
11/03/2004 42.00 500 21,000.00
11/03/2004 45.75 50,000 2,293,619.06
11/03/2004 46.00 50,000 2,306,152.50
11/03/2004 48.00 10,000 481,284.00
12/03/2004 47.00 50,000 2,356,286.25
12/03/2004 47.50 10,000 476,270.63
Thank You.
[/quote][/list]
What is the code in sheet2 ? When I put data of AOT in sheet1
it will show only data of AOT in sheet2 automaticaly.
Sheet1
BUY
Date Stock Price Volume Total
25/12/2003 LOXLEY 53.50 4,000 214,572.45
06/01/2004 BCP 19.20 10,000 192,513.60
06/01/2004 EGV 11.80 5,000 59,157.83
09/01/2004 SIM 22.20 10,000 222,593.85
09/01/2004 EIC 19.80 2,000 39,705.93
12/01/2004 TT&T 5.95 10,000 59,659.16
12/01/2004 KGI 6.50 20,000 130,347.75
13/01/2004 Q-CON 19.70 4,000 79,010.79
13/01/2004 Q-CON 20.30 3,000 61,062.91
16/01/2004 KEST 69.00 10,000 691,845.75
30/01/2004 ZMICO 11.30 50,000 566,511.38
04/02/2004 ZMICO 11.70 50,000 586,564.88
04/02/2004 ZMICO 11.70 50,000 586,564.88
05/02/2004 CK 21.50 50,000 1,077,875.63
06/02/2004 CK 21.50 50,000 1,077,875.63
06/02/2004 ZMICO 12.90 60,000 776,070.45
06/02/2004 SCB-W 12.20 46,800 572,487.32
06/02/2004 SCB-W 12.20 3,200 39,144.43
06/02/2004 ZMICO 12.90 40,000 517,380.30
10/02/2004 SCB-W 12.60 43,000 543,249.32
10/02/2004 SCB-W 12.60 7,000 88,435.94
11/02/2004 SCB-W 13.20 50,000 661,765.50
12/02/2004 SCB-W 13.50 17,000 230,113.91
12/02/2004 SCB-W 13.50 3,000 40,608.34
16/02/2004 SCB-W 13.70 50,000 686,832.38
11/02/2004 SCB-W 13.20 50,000 661,765.50
24/02/2004 bay 11.90 10,000 119,318.33
24/02/2004 bay 11.80 40,000 473,262.60
01/03/2004 itd 105.00 5,000 526,404.38
11/03/2004 AOT 42.00 500 21,000.00
11/03/2004 AOT 45.75 50,000 2,293,619.06
11/03/2004 AOT 46.00 50,000 2,306,152.50
11/03/2004 AOT 48.00 10,000 481,284.00
12/03/2004 aot 47.00 50,000 2,356,286.25
12/03/2004 aot 47.50 10,000 476,270.63
02/04/2004 scib-c1 5.20 200,000 1,042,782.00
02/04/2004 scb-w 8.30 100,000 832,220.25
02/04/2004 scb-w 8.30 50,000 416,110.13
05/04/2004 kest 56.00 30,000 1,684,494.00
Sheet2
AOT
Date Price Volume Total
11/03/2004 42.00 500 21,000.00
11/03/2004 45.75 50,000 2,293,619.06
11/03/2004 46.00 50,000 2,306,152.50
11/03/2004 48.00 10,000 481,284.00
12/03/2004 47.00 50,000 2,356,286.25
12/03/2004 47.50 10,000 476,270.63
Thank You.
[/quote][/list]