Hi Hernan

You can use Autofilter on the column and copy the visible data to another
sheet

Activate AutoFilter:

Select a cell in your data table and use DataFilterAutoFilter to activate
AutoFilter.
Tip: Shortcut for the English version is Alt d f f

In each header cell a dropdown will appear next to your field name.
Click on the dropdown in the status field and choose OUT.

Copy the filter result :

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5SpecialCurrent regionOK
3) Ctrl c or EditCopy
4) InsertWorksheet
5) Ctrl v or EditPaste
6) Select the sheet with the filter
7) Press Esc
8) Press Alt d f f or DataFilterAutoFilter to turn off AutoFilter


Or use my filter add-in
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Hernan" wrote in message
...
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