PDA

View Full Version : Sleeper: Moving cotents of a cell



Tenspeed39355
09-19-2005, 04:50 PM
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:friends:

royUK
09-19-2005, 11:51 PM
Can't you just use a formula approach or do you want to do it dynamically?

Tenspeed39355
09-20-2005, 03:55 AM
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
09-20-2005, 04:15 AM
can you attach a small zipped example?

malik641
09-20-2005, 05:10 AM
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:friends: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?