B
Bourbon
My table looks like this (in excel). I wrote the code to create a
graphic using columm A and B. What I want to do is a code that will
search columm C (Recommendation) and when it finds an entry (B, S, H OR
TP), creates a text box with the date from the corresponding row, the
recommendation-Target price....The attached file shows and manualy done
preview....
Can anyone help me?
Regards,
Bourbon
Date Price Recommendation Target
10/6/00 33.25
10/13/00 33.25
10/20/00 44.95
10/27/00 39.5
11/3/00 48.75 B 10.00
11/10/00 46.225
11/17/00 41.8
11/24/00 38
12/1/00 30.625
12/8/00 31.35
12/15/00 30
12/22/00 31
12/29/00 34.4
1/5/01 31.5
1/12/01 28.75
1/19/01 31.75
1/26/01 35
2/2/01 36
2/9/01 33.375
2/16/01 31.5
2/23/01 29.375 B 12.00
3/2/01 33.5
3/9/01 34.745
3/16/01 32.775
3/23/01 30
3/30/01 31.25
4/6/01 29.125
4/13/01 32.625
4/20/01 33
4/27/01 33.25
5/4/01 34.45
5/11/01 36.45 S 10.00
5/18/01 37.425
5/25/01 36.5
6/1/01 36.25
6/8/01 35.35
6/15/01 35
6/22/01 37.275
6/29/01 39.725
7/6/01 39.76
7/13/01 38.755
7/20/01 40.5 H 5.00
7/27/01 40
8/3/01 41.305
8/10/01 40.585
8/17/01 38.05
8/24/01 43.925
8/31/01 44.2
9/7/01 29.245
9/14/01 23.75
9/21/01 28.2 TP 15.00
9/28/01 34.035
10/5/01 35.195
10/12/01 34.26
10/19/01 33.68
10/26/01 36.825
11/2/01 38.57
11/9/01 35.445
11/16/01 39.625
11/23/01 39.495
11/30/01 43.335
12/7/01 41
12/14/01 39.085
12/21/01 41.625
12/28/01 44.6
1/4/02 43.125
1/11/02 43.375
1/18/02 42.94
1/25/02 43
2/1/02 44.32
2/8/02 42.75
2/15/02 42.65
2/22/02 42.67
3/1/02 32.55
3/8/02 36.625
3/15/02 36.65
3/22/02 37.345
3/29/02 36.3
4/5/02 36
4/12/02 35.545
4/19/02 36.875
4/26/02 31.05
5/3/02 31.255
5/10/02 31.325
5/17/02 33.375
5/24/02 33.125
5/31/02 30.505
6/7/02 31.485
6/14/02 30
6/21/02 31
6/28/02 28.345
7/5/02 28
7/12/02 26
7/19/02 26.89 TP 20.00
7/26/02 29.365
8/2/02 34.55
8/9/02 35.025
8/16/02 34.875
8/23/02 35.15
8/30/02 35.1
9/6/02 34.845
9/13/02 33.8
9/20/02 32.23
9/27/02 31.235
10/4/02 28.1
10/11/02 26.625
10/18/02 27.875
10/25/02 30.865
11/1/02 28.7
11/8/02 28.725
11/15/02 27.79
11/22/02 29.445
11/29/02 29.75
12/6/02 28.905
12/13/02 27.625
12/20/02 26.55
12/27/02 26.95
1/3/03 28.225
1/10/03 26.75
1/17/03 25.76
1/24/03 27.75
1/31/03 27.775
2/7/03 27.35
2/14/03 27.235
2/21/03 27.78
2/28/03 29.225
3/7/03 29.4
3/14/03 31.25
3/21/03 33.5
3/28/03 29.08
4/4/03 31.91
4/11/03 31.5
4/18/03 30.97
4/25/03 33.45
5/2/03 34.65
5/9/03 35.11
5/16/03 38.6
5/23/03 39
5/30/03 40.76
6/6/03 44.48
6/13/03 54.6
6/20/03 53.5
6/27/03 56.55
7/4/03 57.75
7/11/03 60.02
7/18/03 56.35
7/25/03 58.95
8/1/03 61.41
8/8/03 61.3
8/15/03 62.5
8/22/03 62.75
8/29/03 59.51
9/5/03 53.5
9/12/03 59.65
9/19/03 65.35
9/26/03 60.16
10/3/03 62.11
10/10/03 56.82
10/17/03 56
10/24/03 56.54
10/31/03 60.02
11/7/03 56.35
11/14/03 58.95
11/21/03 61.41
11/28/03 61.3
12/5/03 62.5
12/12/03 62.75
12/19/03 59.51
12/26/03 53.5
1/2/04 59.65
1/9/04 65.35
1/16/04 60.16
1/23/04 62.11
1/30/04 56.82
2/6/04 56
2/13/04 56.54
2/20/04 62.5
2/27/04 62.75
3/5/04 59.51
3/12/04 53.5
3/19/04 59.65
3/26/04 65.35
4/2/04 60.16
4/9/04 62.11
4/16/04 56.82
4/23/04 56
4/30/04 56.54
5/7/04 60.02
5/14/04 56.35
5/21/04 58.95
5/28/04 61.41
6/4/04 61.3
6/11/04 62.5
6/18/04 62.75
6/25/04 59.51
7/2/04 53.5
7/9/04 59.65
7/16/04 65.35
7/23/04 60.16
7/30/04 62.11
8/6/04 56.82
8/13/04 56
8/20/04 56.54
8/27/04 53.5 B 15.00
9/3/04 59.65
9/10/04 65.35
9/17/04 60.16
9/24/04 62.11
10/1/04 56.82
10/8/04 56
10/15/04 56.54
10/22/04 60.02
10/29/04 56.35
11/5/04 58.95
11/12/04 61.41
11/19/04 61.3
11/26/04 62.5
12/3/04 62.75
12/10/04 59.51
12/17/04 53.5
12/24/04 59.65
12/31/04 65.35
1/7/05 60.16
1/14/05 62.11
1/21/05 56.82
1/28/05 56
2/4/05 56.54 TP 25.00
2/11/05 56.35
2/18/05 58.95
2/25/05 61.41
3/4/05 61.3
3/11/05 62.5
3/18/05 62.75
3/25/05 59.51
4/1/05 53.5
4/8/05 59.65
4/15/05 65.35
4/22/05 60.16
4/29/05 62.11
5/6/05 56.82
5/13/05 56
5/20/05 56.54
5/27/05 62.11
6/3/05 56.82
6/10/05 56
6/17/05 56.54
6/24/05 56.35
7/1/05 58.95
7/8/05 61.41
7/15/05 61.3
7/22/05 62.5
7/29/05 62.75
8/5/05 59.51
8/12/05 53.5
8/19/05 59.65
8/26/05 65.35
9/2/05 60.16
9/9/05 62.11
9/16/05 56.82
9/23/05 56
9/30/05 56.54
Attachment filename: test-macro.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=401652
graphic using columm A and B. What I want to do is a code that will
search columm C (Recommendation) and when it finds an entry (B, S, H OR
TP), creates a text box with the date from the corresponding row, the
recommendation-Target price....The attached file shows and manualy done
preview....
Can anyone help me?
Regards,
Bourbon
Date Price Recommendation Target
10/6/00 33.25
10/13/00 33.25
10/20/00 44.95
10/27/00 39.5
11/3/00 48.75 B 10.00
11/10/00 46.225
11/17/00 41.8
11/24/00 38
12/1/00 30.625
12/8/00 31.35
12/15/00 30
12/22/00 31
12/29/00 34.4
1/5/01 31.5
1/12/01 28.75
1/19/01 31.75
1/26/01 35
2/2/01 36
2/9/01 33.375
2/16/01 31.5
2/23/01 29.375 B 12.00
3/2/01 33.5
3/9/01 34.745
3/16/01 32.775
3/23/01 30
3/30/01 31.25
4/6/01 29.125
4/13/01 32.625
4/20/01 33
4/27/01 33.25
5/4/01 34.45
5/11/01 36.45 S 10.00
5/18/01 37.425
5/25/01 36.5
6/1/01 36.25
6/8/01 35.35
6/15/01 35
6/22/01 37.275
6/29/01 39.725
7/6/01 39.76
7/13/01 38.755
7/20/01 40.5 H 5.00
7/27/01 40
8/3/01 41.305
8/10/01 40.585
8/17/01 38.05
8/24/01 43.925
8/31/01 44.2
9/7/01 29.245
9/14/01 23.75
9/21/01 28.2 TP 15.00
9/28/01 34.035
10/5/01 35.195
10/12/01 34.26
10/19/01 33.68
10/26/01 36.825
11/2/01 38.57
11/9/01 35.445
11/16/01 39.625
11/23/01 39.495
11/30/01 43.335
12/7/01 41
12/14/01 39.085
12/21/01 41.625
12/28/01 44.6
1/4/02 43.125
1/11/02 43.375
1/18/02 42.94
1/25/02 43
2/1/02 44.32
2/8/02 42.75
2/15/02 42.65
2/22/02 42.67
3/1/02 32.55
3/8/02 36.625
3/15/02 36.65
3/22/02 37.345
3/29/02 36.3
4/5/02 36
4/12/02 35.545
4/19/02 36.875
4/26/02 31.05
5/3/02 31.255
5/10/02 31.325
5/17/02 33.375
5/24/02 33.125
5/31/02 30.505
6/7/02 31.485
6/14/02 30
6/21/02 31
6/28/02 28.345
7/5/02 28
7/12/02 26
7/19/02 26.89 TP 20.00
7/26/02 29.365
8/2/02 34.55
8/9/02 35.025
8/16/02 34.875
8/23/02 35.15
8/30/02 35.1
9/6/02 34.845
9/13/02 33.8
9/20/02 32.23
9/27/02 31.235
10/4/02 28.1
10/11/02 26.625
10/18/02 27.875
10/25/02 30.865
11/1/02 28.7
11/8/02 28.725
11/15/02 27.79
11/22/02 29.445
11/29/02 29.75
12/6/02 28.905
12/13/02 27.625
12/20/02 26.55
12/27/02 26.95
1/3/03 28.225
1/10/03 26.75
1/17/03 25.76
1/24/03 27.75
1/31/03 27.775
2/7/03 27.35
2/14/03 27.235
2/21/03 27.78
2/28/03 29.225
3/7/03 29.4
3/14/03 31.25
3/21/03 33.5
3/28/03 29.08
4/4/03 31.91
4/11/03 31.5
4/18/03 30.97
4/25/03 33.45
5/2/03 34.65
5/9/03 35.11
5/16/03 38.6
5/23/03 39
5/30/03 40.76
6/6/03 44.48
6/13/03 54.6
6/20/03 53.5
6/27/03 56.55
7/4/03 57.75
7/11/03 60.02
7/18/03 56.35
7/25/03 58.95
8/1/03 61.41
8/8/03 61.3
8/15/03 62.5
8/22/03 62.75
8/29/03 59.51
9/5/03 53.5
9/12/03 59.65
9/19/03 65.35
9/26/03 60.16
10/3/03 62.11
10/10/03 56.82
10/17/03 56
10/24/03 56.54
10/31/03 60.02
11/7/03 56.35
11/14/03 58.95
11/21/03 61.41
11/28/03 61.3
12/5/03 62.5
12/12/03 62.75
12/19/03 59.51
12/26/03 53.5
1/2/04 59.65
1/9/04 65.35
1/16/04 60.16
1/23/04 62.11
1/30/04 56.82
2/6/04 56
2/13/04 56.54
2/20/04 62.5
2/27/04 62.75
3/5/04 59.51
3/12/04 53.5
3/19/04 59.65
3/26/04 65.35
4/2/04 60.16
4/9/04 62.11
4/16/04 56.82
4/23/04 56
4/30/04 56.54
5/7/04 60.02
5/14/04 56.35
5/21/04 58.95
5/28/04 61.41
6/4/04 61.3
6/11/04 62.5
6/18/04 62.75
6/25/04 59.51
7/2/04 53.5
7/9/04 59.65
7/16/04 65.35
7/23/04 60.16
7/30/04 62.11
8/6/04 56.82
8/13/04 56
8/20/04 56.54
8/27/04 53.5 B 15.00
9/3/04 59.65
9/10/04 65.35
9/17/04 60.16
9/24/04 62.11
10/1/04 56.82
10/8/04 56
10/15/04 56.54
10/22/04 60.02
10/29/04 56.35
11/5/04 58.95
11/12/04 61.41
11/19/04 61.3
11/26/04 62.5
12/3/04 62.75
12/10/04 59.51
12/17/04 53.5
12/24/04 59.65
12/31/04 65.35
1/7/05 60.16
1/14/05 62.11
1/21/05 56.82
1/28/05 56
2/4/05 56.54 TP 25.00
2/11/05 56.35
2/18/05 58.95
2/25/05 61.41
3/4/05 61.3
3/11/05 62.5
3/18/05 62.75
3/25/05 59.51
4/1/05 53.5
4/8/05 59.65
4/15/05 65.35
4/22/05 60.16
4/29/05 62.11
5/6/05 56.82
5/13/05 56
5/20/05 56.54
5/27/05 62.11
6/3/05 56.82
6/10/05 56
6/17/05 56.54
6/24/05 56.35
7/1/05 58.95
7/8/05 61.41
7/15/05 61.3
7/22/05 62.5
7/29/05 62.75
8/5/05 59.51
8/12/05 53.5
8/19/05 59.65
8/26/05 65.35
9/2/05 60.16
9/9/05 62.11
9/16/05 56.82
9/23/05 56
9/30/05 56.54
Attachment filename: test-macro.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=401652