I think I understand what you want except for the phrase "in a different
column". Explain that please.
I take it that you download stock data into one or more rows of sheet
one. And you want all the data in sheet one transferred to sheet 2 but one
column to the right leaving Column A of each row for today's date. Is that
correct? HTH Otto

"garr" <not_this_1@Try.again> wrote in message
news:FhCRd.431821$6l.423743@pd7tw2no...
> This is a little more info on what I'm tring to do
> I have down loaded stock info into sheet 1 and would like to transfer it
> to sheet 2. Each piece of info in the cells in sheet one will be
> transferred to cells in sheet two into a different column with a date of
> that day at the beginning of each row on sheet two. Every day I will
> update sheet one and would like it to update the info on sheet two in the
> next row down and not update the previous row (leave the previous row with
> the last days info)
>
> Garr
>
>
>
> "garr" <not_this_1@Try.again> wrote in message
> news:iBfRd.417671$6l.364472@pd7tw2no...
>> I'm using Excel 2003
>> I have a workbook open and am using 2 worksheets. On sheet 1 I get
>> information from the internet and then transfer three cells of it to
>> sheet
>> 2. Sheet 1 updates every time I open the workbook. How do I get sheet 1
>> to
>> put the information into a different cell in sheet 2 each time it
>> updates. I
>> would like to get them to follow the dates down a column.
>>
>> Garry
>> gtpighin@shaw.ca
>>
>>
>>
>
>