Well changing the two, to the name of the second sheet did work, but this
macro enters the date starting in A1 then in A2 and B2 and so on in sheet 2.
"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