HI, this is an ongoing matter. I cant seem to type out a specific word
for it to search for exactly what I am trying to do.

So I'll explain it.


This is what I need. I have baseball odds that are brought into excel
directly from a website. The webpage, tables are positioned in the
right spot on the sheet.

Then on another sheet I have the odds without all the other webpage
garbage..

quick eg.

bos ny ks chic
-112 112 110 -110 say..

this refreshes over and over..

what I want is the last data to drop the the next cell lower.. and the
new data to be in the old datas original spot

so in 2 hours Id have something like...

bos ny ks chic
-112 112 110 -110
-110 105 105 -120
-105 112 110 -110

but a full list.. how do i make a cell turn into text and place itself
below in the cell right below??

Is it something simple, ive searched 8 hours 10 times a year for the
last 3 years.. and keep givin up.

lol thanks for ANY help anyone can give me.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

You need code to do it - VBA code that is. You can
try recording it yourself by using the macro recorder
on the Tools -- Macro menu and just do it for one
set of data.

I cannot actually help you cos I do not understand the
stats you have and cannot work out what you are trying
to do with them. The stats we use for the games we play
are a little different.

Chrissy.

0o0o0 wrote
HI, this is an ongoing matter. I cant seem to type out a specific word
for it to search for exactly what I am trying to do.

So I'll explain it.


This is what I need. I have baseball odds that are brought into excel
directly from a website. The webpage, tables are positioned in the
right spot on the sheet.

Then on another sheet I have the odds without all the other webpage
garbage..

quick eg.

bos ny ks chic
-112 112 110 -110 say..

this refreshes over and over..

what I want is the last data to drop the the next cell lower.. and the
new data to be in the old datas original spot

so in 2 hours Id have something like...

bos ny ks chic
-112 112 110 -110
-110 105 105 -120
-105 112 110 -110

but a full list.. how do i make a cell turn into text and place itself
below in the cell right below??

Is it something simple, ive searched 8 hours 10 times a year for the
last 3 years.. and keep givin up.

lol thanks for ANY help anyone can give me.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

that was a fast reply!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Stocks.. during the day I want to see buy orders placed, without paying
for a $300 dollar program.. so lets say this stock here at this site..
These are the institutions buying, but while im out I dont want to miss
who bought in at higher than average shares.

heres the addy..

http://tinyurl.com/qm07

table 27 ( which isnt showing anything right now cause the markets are
closed but table 27 does have 10 last trades at a time... )



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Send me your workbook with the query and I will take a look.
FULLY explain what you want.

"0o0o0" wrote in message
...
Stocks.. during the day I want to see buy orders placed, without paying
for a $300 dollar program.. so lets say this stock here at this site..
These are the institutions buying, but while im out I dont want to miss
who bought in at higher than average shares.

heres the addy..

http://tinyurl.com/qm07

table 27 ( which isnt showing anything right now cause the markets are
closed but table 27 does have 10 last trades at a time... )



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/