You could use formulas in 5 columns on the target sheet that would show the
information if status is OUT

Assuming your source sheet is named "Source"(no quotes)

In A1 of target sheet =IF(Source!$E1="OUT",Source!A1,"")

Drag across to E1 and down to wherever.

To actually "move" the data without formulas would require VBA


Gord Dibben MS Excel MVP

On Sun, 3 Dec 2006 10:55:01 -0800, Hernan
wrote:

Hello,

The sheet I have has 5 columns and the 5th is for status, IN or OUT.

What I want is to MOVE the row to another worksheet in the same workbook IF
the status is OUT.

TIA

Hernan