Updating in a new cell

[MarieN]

I would like to take external data of stock price and update it in a new cell every minute. I know how to take the data to excel and how to update it. What I need help with is how you make excel, every time the data is updated, jump down the new price to a cell right under so I get a long list with minute-data of the stock prices.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Is this possible?

 

[onlyadrafter]

Hello,

something on the line of

range("A" & rows.count).end(xlup).offset(1,0)

will get the next cell down in Col A.