Auto refresh stock value copied to next row

[pucha]

Hi

I am importing the data (Stock) in this manner, (A1 to A4) & (B1 to B4). I am using Excel 2003.

I am using auto refresh for one minute.

A1 | Feb 24, 10:35

A2 | 28889.00 243.00 (0.85%)

A3 | Volume

A4 | 40181


B1 | Low

B2 | High

B3 | 28723

B4 | 28944


Firstly, I would like these data to be in a single row.

| Date & Time | High | Low | Volume | Stock Price | Point Change | % Change |

| Feb 24, 10.35 | 28944 | 28723 | 40181 | 28889 | 243 | 0.85 |


Secondly, breaking the data imported in a single cell i.e (28889.00 243.00 (0.85%)) into (Stock Price, Point Change & % Change) and finally placing them in a row as above.


Thirdly, after auto refresh every minute, I want to copy the stock Row to next Row automatically.


Thanks in advance.

With Regards.

 

[Luke M]

Check out your previous thread where I think I answered this.

http://chandoo.org/forums/topic/auto-refresh-stock-value-copied-to-next-row

 

[pucha]

Hi Luke M


Sorry for late reply.

Thank you once again for solving this problem. I am really great full to you. It works like the way I needed.


With regards