I am still having a problem with what you sent. Lets try the following.
Would you please make up a macro that will start in Sheet2 A1 and go to A25.
The stock symbols will be in that range. When the macro starts going from A1 to A25
each time it moves to the next cell it will also change the symbol in Sheet1 A1. Each time
Sheet1 A1 changes I want Sheet1 J255 to enter the new number in Sheet2 B1 and when
Sheet1 A1 changes again the new number in J255 will go to Sheet2 B2. I can get the symbols in Sheet1 A1 to change the problem I am having is that each time the numbers in J255 change the number in Sheet2 B1 changes to the new number. The old number will not stay in B1. If I can get the number in B1 and B2 to be different numbers that will solve the problem. I have sent you the ss before. Hope you can help me with this problem.
Max