"if" cell = "X" then move it's row to another sheet

[agant]

I would like to move a row to another sheet if the first column in the row is earlier than the currnet date

 

[Vasant Nanavati]

A little more detail would help.

What sheet do you want to move the row to?

Where on the sheet do you want to move it to?

When do you want to perform the test to determine whether to move it?

--

Vasant

I would like to move a row to another sheet if the first column in the row

is earlier than the currnet date

 

[Frank Kabel]

Hi
as you didn't provide that much information have a look at the
following site as starting point:
http://www.rondebruin.nl/copy5.htm