Hi I tried you code but was having prolems with it. I hope this will explain what the
problem is. I have 450 funds symbols in column A In column B I want to put a number
from Tab 2. I have used the recorder to link each symbol in column A to A1 in Tab 2. When I run the macro the number I want in comes up in Column B1 which is good. Now here is the problem. When the macro goes to B2 the NEW NUMBER comes up correctly.
The problem is the number that was in B1 now becomes the number in B2. This goes on until all the numbers are beside the symbols, but they are all what the last number is. How can I get the numbers for each symbol to stay the same.
Example of what I see
AOF 6.35
ACG 6.35
ASG 6.35


This is what I want it to look like
AOF 6.35
ACG 3.25
ASG 10.00
I appreate any help on this.
I can not send the ss as I am using a program that changes the number I am after in Tab two when the market price changes. I know the number is changing because
lets say the first symbol is AOF, the number comes up beside it but when the new
symbol comes up and the new number comes up the first number changes to the new
number in B!.
Thanks in advance.
Max