Sleeper: Moving cotents of a cell

[Tenspeed39355]

I have been at this for some time with no results. Here is the problem.
I have a list of stock symbols in Sheet1 A2:A650.I want to copy them one at a time to Sheet2 A2. When the symbol is copied there are some calulations in
Sheet2 B2,C2,D2 that will be made by looking over into Yahoo. When the calulations are made the results will show up in Column F, F2. How do I get the results in F2 to show up in sheet2 column B. In other words I want to populate
Column B B2:B650 with the results of Sheet1 Column F, F2.
Thanks for your help as I am dead in the water
Max

[royUK]

Can't you just use a formula approach or do you want to do it dynamically?

[Tenspeed39355]

I want to do it dynamially. When I run the macro I want the macro to step thru each
symbol and put the results beside each symbol. The result comes from Sheet1 col F
Cell F2
Max

[royUK]

can you attach a small zipped example?

[malik641]

I have a list of stock symbols in Sheet1 A2:A650.I want to copy them one at a time to Sheet2 A2. When the symbol is copied there are some calulations in
Sheet2 B2,C2,D2 that will be made by looking over into Yahoo. When the calulations are made the results will show up in Column F, F2. How do I get the results in F2 to show up in sheet2 column B. In other words I want to populate
Column B B2:B650 with the results of Sheet1 Column F, F2.
Thanks for your help as I am dead in the water
Max

So you're saying to:
1: Copy symbols from Sheet1 A2:A650 ---> Sheet2 A2:Axx
2: Sheet2 will then calculate a couple of things by looking into yahoo
3: Results will show in Sheet1 F2:Fxx
4: Take those results and REPLACE the formulas that were in Col B of Sheet2 with the results from Col F in Sheet1?

Right?