If statement

D

Dohickle

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.
 
R

Roger Govier

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,"")
 
Top