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" 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" 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