Garr
Provide some detail about the layout of your data in each sheet. HTH
Otto
"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