you really need VBA, but you should give more info? what do you mean with
"i need to write a statement in excel that will copy dates to another
spreadsheet in the correct cell based on the dates"
you're copiing dates based on dates?

....and also i need it to move down a row once the 1st row is full..
move down: ActiveCell.Offset(RowOffset:=1, ColumnOffset:=0)
"newexceluser" wrote in message
...
i need to write a statement in excel that will copy dates to another
spreadsheet in the correct cell based on the dates and also i need it to
move
down a row once the 1st row is full.
I am very new at writing statements so any help would be great.
thanks