Hi

You cannot use any formula to cause a cell to be copied to another
sheet.
You can make the contents of a cell equal the value held in another cell
on another sheet.
For example, on Sheet1
=IF(J2<TODAY(),Sheet2!A1,"")


--
Regards

Roger Govier


"Dohickle" wrote in message
...
I need a statement that (+IF (j2) < today etc) that if this is true
will copy
that cell from one sheet to another sheet can anyone help please.