writing a statement

N

newexceluser

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
 
S

Sasa Stankovic

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"
Click to expand...
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)
 
Top